PREVIEW / etf_30min / 2020-03-31

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-31.parquet
  size:    581 KB
  rows:    21,432

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-03-31 04:00:00	SPY	ETF	262.74	263.79	262.5	263.78	58870.0
2020-03-31 04:30:00	SPY	ETF	263.68	263.9	263.0	263.3	41737.0
2020-03-31 05:00:00	SPY	ETF	263.46	263.75	263.14	263.39	23354.0
2020-03-31 05:30:00	SPY	ETF	263.61	263.61	262.46	263.01	68565.0
2020-03-31 06:00:00	SPY	ETF	262.93	262.96	261.39	261.57	75664.0
2020-03-31 06:30:00	SPY	ETF	261.66	262.3	261.05	261.18	124487.0
2020-03-31 07:00:00	SPY	ETF	261.26	261.41	260.48	260.7	430037.0
2020-03-31 07:30:00	SPY	ETF	260.96	261.04	259.96	260.43	499940.0
2020-03-31 08:00:00	SPY	ETF	260.8299	263.46	257.67	258.85	2186650.0
2020-03-31 08:30:00	SPY	ETF	258.85	259.7	258.36	259.4499	913274.0
2020-03-31 09:00:00	SPY	ETF	259.45	260.79	259.25	260.6	1213773.0
2020-03-31 09:30:00	SPY	ETF	260.56	260.92	258.286	259.19	15596465.0
2020-03-31 10:00:00	SPY	ETF	259.16	262.93	259.13	261.94	14187494.0
2020-03-31 10:30:00	SPY	ETF	261.94	263.25	261.75	261.79	12036314.0
2020-03-31 11:00:00	SPY	ETF	261.8	262.93	261.0	262.8616	8659086.0
2020-03-31 11:30:00	SPY	ETF	262.86	263.33	261.99	262.515	8061543.0
2020-03-31 12:00:00	SPY	ETF	262.51	262.71	259.94	260.51	8419225.0
2020-03-31 12:30:00	SPY	ETF	260.51	260.54	258.52	259.3767	11558097.0
2020-03-31 13:00:00	SPY	ETF	259.36	260.18	257.94	258.68	10473538.0
2020-03-31 13:30:00	SPY	ETF	258.66	260.31	258.06	260.1	6820259.0
2020-03-31 14:00:00	SPY	ETF	260.09	260.25	258.77	259.84	8549831.0
2020-03-31 14:30:00	SPY	ETF	259.84	260.64	259.18	259.8084	7551244.0
2020-03-31 15:00:00	SPY	ETF	259.805	260.4537	256.22	256.71	16273807.0
2020-03-31 15:30:00	SPY	ETF	256.71	258.64	256.47	257.7	31036125.0
2020-03-31 16:00:00	SPY	ETF	257.71	258.582	256.26	256.66	12815709.0
2020-03-31 16:30:00	SPY	ETF	256.65	257.6625	256.02	256.74	9087348.0
2020-03-31 17:00:00	SPY	ETF	256.69	257.75	256.69	257.01	536044.0
2020-03-31 17:30:00	SPY	ETF	257.05	257.75	256.75	256.75	229486.0
2020-03-31 18:00:00	SPY	ETF	256.75	257.75	254.66	255.26	792084.0
2020-03-31 18:30:00	SPY	ETF	255.19	255.19	254.16	255.05	222469.0
2020-03-31 19:00:00	SPY	ETF	255.0	255.37	254.21	254.48	296776.0
2020-03-31 19:30:00	SPY	ETF	254.45	254.98	254.19	254.31	275754.0
2020-03-31 04:00:00	QQQ	ETF	193.27	194.05	193.13	194.03	68515.0
2020-03-31 04:30:00	QQQ	ETF	193.98	194.03	193.5	193.81	59473.0
2020-03-31 05:00:00	QQQ	ETF	193.84	194.29	193.69	194.04	44289.0
2020-03-31 05:30:00	QQQ	ETF	194.16	194.17	193.39	193.7	80350.0
2020-03-31 06:00:00	QQQ	ETF	193.65	193.65	192.63	192.67	28029.0
2020-03-31 06:30:00	QQQ	ETF	192.64	192.98	192.14	192.24	52138.0
2020-03-31 07:00:00	QQQ	ETF	192.28	192.37	191.8	192.0	112002.0
2020-03-31 07:30:00	QQQ	ETF	192.09	192.25	191.55	192.14	115378.0
2020-03-31 08:00:00	QQQ	ETF	192.03	194.05	189.62	190.38	932522.0
2020-03-31 08:30:00	QQQ	ETF	190.39	190.95	189.94	190.65	437758.0
2020-03-31 09:00:00	QQQ	ETF	190.63	191.8	190.52	191.59	401447.0
2020-03-31 09:30:00	QQQ	ETF	191.55	192.32	190.43	191.02	5676880.0
2020-03-31 10:00:00	QQQ	ETF	191.01	194.71	190.99	194.32	5636102.0
2020-03-31 10:30:00	QQQ	ETF	194.3515	195.25	193.72	193.775	4133913.0
2020-03-31 11:00:00	QQQ	ETF	193.78	194.45	193.1	194.347	2551403.0
2020-03-31 11:30:00	QQQ	ETF	194.34	194.6	193.2007	193.7	2106677.0
2020-03-31 12:00:00	QQQ	ETF	193.7	193.89	191.78	192.23	2699495.0
2020-03-31 12:30:00	QQQ	ETF	192.24	192.44	190.87	191.59	3572893.0

> showing 50 of 21,432 rows — these rows as CSV

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