PREVIEW / etf_30min / 2020-07-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-27.parquet
  size:    552 KB
  rows:    20,571

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-07-27 04:00:00	SPY	ETF	321.52	321.96	321.52	321.7	20592.0
2020-07-27 04:30:00	SPY	ETF	321.73	321.97	321.51	321.51	7558.0
2020-07-27 05:00:00	SPY	ETF	321.59	322.1	321.47	322.1	8638.0
2020-07-27 05:30:00	SPY	ETF	322.04	322.16	321.83	322.09	31980.0
2020-07-27 06:00:00	SPY	ETF	322.05	322.29	321.88	322.28	21405.0
2020-07-27 06:30:00	SPY	ETF	322.33	322.37	322.06	322.08	23647.0
2020-07-27 07:00:00	SPY	ETF	322.07	322.08	321.66	322.03	59879.0
2020-07-27 07:30:00	SPY	ETF	322.01	322.39	322.0	322.35	71915.0
2020-07-27 08:00:00	SPY	ETF	322.1004	322.38	320.88	322.25	289178.0
2020-07-27 08:30:00	SPY	ETF	322.23	322.23	321.4	321.75	126960.0
2020-07-27 09:00:00	SPY	ETF	321.7	321.9	321.56	321.62	126636.0
2020-07-27 09:30:00	SPY	ETF	321.63	322.73	320.775	322.62	6304753.0
2020-07-27 10:00:00	SPY	ETF	322.62	322.9	322.38	322.56	3603705.0
2020-07-27 10:30:00	SPY	ETF	322.57	322.97	322.36	322.6	3280424.0
2020-07-27 11:00:00	SPY	ETF	322.59	322.64	321.62	321.745	3304815.0
2020-07-27 11:30:00	SPY	ETF	321.75	322.035	321.18	321.9	3058610.0
2020-07-27 12:00:00	SPY	ETF	321.9	322.25	321.75	322.2	3374188.0
2020-07-27 12:30:00	SPY	ETF	322.2	322.46	322.085	322.37	1032529.0
2020-07-27 13:00:00	SPY	ETF	322.39	322.67	322.3087	322.65	2062204.0
2020-07-27 13:30:00	SPY	ETF	322.64	322.76	322.44	322.49	1396010.0
2020-07-27 14:00:00	SPY	ETF	322.5	322.84	322.295	322.7701	2217920.0
2020-07-27 14:30:00	SPY	ETF	322.77	322.9	322.17	322.38	1718199.0
2020-07-27 15:00:00	SPY	ETF	322.385	323.28	322.35	323.18	4792688.0
2020-07-27 15:30:00	SPY	ETF	323.17	323.41	322.97	323.18	6529242.0
2020-07-27 16:00:00	SPY	ETF	323.18	323.38	323.08	323.29	3035166.0
2020-07-27 16:30:00	SPY	ETF	323.3	323.52	323.24	323.47	150569.0
2020-07-27 17:00:00	SPY	ETF	323.42	323.56	323.22	323.53	78299.0
2020-07-27 17:30:00	SPY	ETF	323.52	323.6	323.41	323.53	39609.0
2020-07-27 18:00:00	SPY	ETF	323.59	323.76	323.59	323.7	25525.0
2020-07-27 18:30:00	SPY	ETF	323.73	323.86	323.55	323.55	65873.0
2020-07-27 19:00:00	SPY	ETF	323.7	323.8	323.31	323.31	42597.0
2020-07-27 19:30:00	SPY	ETF	323.34	323.77	323.3	323.7	34415.0
2020-07-27 04:00:00	QQQ	ETF	256.64	256.89	256.55	256.57	35557.0
2020-07-27 04:30:00	QQQ	ETF	256.75	256.92	256.59	256.64	13030.0
2020-07-27 05:00:00	QQQ	ETF	256.68	257.22	256.68	257.22	12355.0
2020-07-27 05:30:00	QQQ	ETF	257.16	257.44	257.16	257.36	18290.0
2020-07-27 06:00:00	QQQ	ETF	257.33	258.03	257.11	258.03	29430.0
2020-07-27 06:30:00	QQQ	ETF	258.03	258.26	257.81	257.86	44826.0
2020-07-27 07:00:00	QQQ	ETF	257.81	257.83	257.4	257.72	52851.0
2020-07-27 07:30:00	QQQ	ETF	257.61	258.02	257.61	258.0	85857.0
2020-07-27 08:00:00	QQQ	ETF	257.2504	258.24	256.34	257.58	118388.0
2020-07-27 08:30:00	QQQ	ETF	257.6	257.61	257.12	257.37	93867.0
2020-07-27 09:00:00	QQQ	ETF	257.37	257.57	257.15	257.28	253702.0
2020-07-27 09:30:00	QQQ	ETF	257.31	259.29	256.52	259.05	4638935.0
2020-07-27 10:00:00	QQQ	ETF	259.08	259.45	257.94	258.19	3100154.0
2020-07-27 10:30:00	QQQ	ETF	258.19	259.01	258.09	258.56	1985671.0
2020-07-27 11:00:00	QQQ	ETF	258.54	258.655	256.91	257.1	2323126.0
2020-07-27 11:30:00	QQQ	ETF	257.13	257.83	256.445	257.6	1938495.0
2020-07-27 12:00:00	QQQ	ETF	257.6	258.12	257.35	257.81	1258839.0
2020-07-27 12:30:00	QQQ	ETF	257.81	258.4499	257.58	258.4	1002787.0

> showing 50 of 20,571 rows — these rows as CSV

> unlock the full archive -- $79 one-time