PREVIEW / etf_30min / 2020-03-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-13.parquet
  size:    646 KB
  rows:    23,546

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-13 04:00:00	SPY	ETF	257.99	260.14	255.35	256.65	189078.0
2020-03-13 04:30:00	SPY	ETF	256.59	256.59	253.35	254.4	104914.0
2020-03-13 05:00:00	SPY	ETF	254.8	257.18	253.28	256.27	172752.0
2020-03-13 05:30:00	SPY	ETF	256.47	258.56	255.79	258.41	139521.0
2020-03-13 06:00:00	SPY	ETF	258.41	259.05	256.82	257.64	176003.0
2020-03-13 06:30:00	SPY	ETF	257.56	258.74	256.79	258.72	210501.0
2020-03-13 07:00:00	SPY	ETF	258.64	260.9	258.42	260.64	642321.0
2020-03-13 07:30:00	SPY	ETF	260.51	260.75	258.25	260.53	1266215.0
2020-03-13 08:00:00	SPY	ETF	260.41	261.8	245.0	261.8	3088843.0
2020-03-13 08:30:00	SPY	ETF	261.84	262.8	261.7	262.54	1255599.0
2020-03-13 09:00:00	SPY	ETF	262.57	263.38	248.11	263.01	2469347.0
2020-03-13 09:30:00	SPY	ETF	263.09	264.11	255.31	256.56	36602663.0
2020-03-13 10:00:00	SPY	ETF	256.56	261.54	255.65	259.33	27861204.0
2020-03-13 10:30:00	SPY	ETF	259.28	259.78	254.21	254.43	24028604.0
2020-03-13 11:00:00	SPY	ETF	254.44	257.1	252.355	252.43	20062134.0
2020-03-13 11:30:00	SPY	ETF	252.4277	254.0	249.58	252.98	20883197.0
2020-03-13 12:00:00	SPY	ETF	252.97	253.66	250.83	252.1596	11586755.0
2020-03-13 12:30:00	SPY	ETF	252.13	257.76	252.0	255.35	14228400.0
2020-03-13 13:00:00	SPY	ETF	255.32	258.9	254.06	258.65	10863855.0
2020-03-13 13:30:00	SPY	ETF	258.65	260.12	256.75	259.33	10988458.0
2020-03-13 14:00:00	SPY	ETF	259.29	259.37	255.42	255.66	15263788.0
2020-03-13 14:30:00	SPY	ETF	255.64	257.26	253.7	257.02	15758383.0
2020-03-13 15:00:00	SPY	ETF	256.98	259.59	256.07	258.97	20658086.0
2020-03-13 15:30:00	SPY	ETF	258.97	271.08	253.24	270.93	56606654.0
2020-03-13 16:00:00	SPY	ETF	270.94	271.474	256.2964	269.14	22866971.0
2020-03-13 16:30:00	SPY	ETF	269.14	271.4897	265.73	267.0	2653083.0
2020-03-13 17:00:00	SPY	ETF	267.04	269.32	266.94	268.82	1871101.0
2020-03-13 17:30:00	SPY	ETF	268.81	269.32	268.35	268.98	933993.0
2020-03-13 18:00:00	SPY	ETF	269.04	272.1	269.04	271.35	1256077.0
2020-03-13 18:30:00	SPY	ETF	271.6	271.69	269.9	269.91	1759886.0
2020-03-13 19:00:00	SPY	ETF	269.91	270.3	269.39	269.61	141478.0
2020-03-13 19:30:00	SPY	ETF	269.51	269.65	267.11	267.45	248205.0
2020-03-13 04:00:00	QQQ	ETF	184.57	185.65	181.69	182.88	156947.0
2020-03-13 04:30:00	QQQ	ETF	182.27	182.27	180.72	181.63	72301.0
2020-03-13 05:00:00	QQQ	ETF	181.43	183.32	180.64	182.86	81446.0
2020-03-13 05:30:00	QQQ	ETF	182.8	184.4	182.0	184.38	78472.0
2020-03-13 06:00:00	QQQ	ETF	184.4	185.21	183.3	184.01	156967.0
2020-03-13 06:30:00	QQQ	ETF	184.15	184.77	183.27	184.66	152607.0
2020-03-13 07:00:00	QQQ	ETF	184.62	186.26	184.62	186.01	405458.0
2020-03-13 07:30:00	QQQ	ETF	186.0	187.0	185.85	186.65	269974.0
2020-03-13 08:00:00	QQQ	ETF	185.63	187.14	175.34	187.14	643700.0
2020-03-13 08:30:00	QQQ	ETF	187.14	187.99	177.32	187.42	331100.0
2020-03-13 09:00:00	QQQ	ETF	187.42	187.8	185.92	187.29	702051.0
2020-03-13 09:30:00	QQQ	ETF	187.0	188.78	182.33	183.47	13487498.0
2020-03-13 10:00:00	QQQ	ETF	183.42	186.67	182.68	185.24	12996462.0
2020-03-13 10:30:00	QQQ	ETF	185.24	185.62	181.84	181.86	8909219.0
2020-03-13 11:00:00	QQQ	ETF	181.87	183.81	180.53	180.58	8089880.0
2020-03-13 11:30:00	QQQ	ETF	180.61	181.8	178.13	180.8908	8984282.0
2020-03-13 12:00:00	QQQ	ETF	180.87	181.35	179.16	180.3627	5211704.0
2020-03-13 12:30:00	QQQ	ETF	180.34	184.34	180.28	182.34	5027080.0

> showing 50 of 23,546 rows — these rows as CSV

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