PREVIEW / etf_30min / 2021-03-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-03.parquet
  size:    645 KB
  rows:    24,497

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
2021-03-03 04:00:00	SPY	ETF	388.78	389.46	388.76	389.13	32612.0
2021-03-03 04:30:00	SPY	ETF	389.12	389.19	388.63	388.91	86475.0
2021-03-03 05:00:00	SPY	ETF	388.99	389.11	388.92	389.0	19286.0
2021-03-03 05:30:00	SPY	ETF	389.01	389.03	388.54	388.85	61749.0
2021-03-03 06:00:00	SPY	ETF	388.87	388.87	388.51	388.75	11215.0
2021-03-03 06:30:00	SPY	ETF	388.71	388.92	388.5	388.81	151699.0
2021-03-03 07:00:00	SPY	ETF	388.87	388.97	388.58	388.65	65431.0
2021-03-03 07:30:00	SPY	ETF	388.63	388.68	388.05	388.1	124197.0
2021-03-03 08:00:00	SPY	ETF	388.84	388.99	387.25	387.46	248390.0
2021-03-03 08:30:00	SPY	ETF	387.42	387.42	385.12	385.77	1120965.0
2021-03-03 09:00:00	SPY	ETF	385.79	386.2	385.1	385.87	745941.0
2021-03-03 09:30:00	SPY	ETF	385.79	386.83	384.33	384.5101	11935835.0
2021-03-03 10:00:00	SPY	ETF	384.49	385.08	383.11	384.0	10778333.0
2021-03-03 10:30:00	SPY	ETF	384.0	385.45	383.29	385.1411	8633570.0
2021-03-03 11:00:00	SPY	ETF	385.13	386.35	384.77	386.3201	5784863.0
2021-03-03 11:30:00	SPY	ETF	386.32	386.45	385.33	385.41	3480197.0
2021-03-03 12:00:00	SPY	ETF	385.43	385.62	384.7	384.935	2847080.0
2021-03-03 12:30:00	SPY	ETF	384.9381	385.5299	384.54	384.58	2868924.0
2021-03-03 13:00:00	SPY	ETF	384.57	385.83	384.33	385.44	4107612.0
2021-03-03 13:30:00	SPY	ETF	385.4506	385.4506	383.78	384.13	4310611.0
2021-03-03 14:00:00	SPY	ETF	384.13	384.32	383.0	383.23	7089890.0
2021-03-03 14:30:00	SPY	ETF	383.215	384.21	382.23	384.035	8855619.0
2021-03-03 15:00:00	SPY	ETF	384.04	384.36	382.52	383.0001	6374521.0
2021-03-03 15:30:00	SPY	ETF	382.9926	383.72	381.31	381.45	15631539.0
2021-03-03 16:00:00	SPY	ETF	381.46	382.001	381.14	381.34	6737863.0
2021-03-03 16:30:00	SPY	ETF	381.31	381.53	381.1	381.27	281396.0
2021-03-03 17:00:00	SPY	ETF	381.23	381.57	381.23	381.45	78265.0
2021-03-03 17:30:00	SPY	ETF	381.45	381.47	381.3	381.45	39033.0
2021-03-03 18:00:00	SPY	ETF	381.45	381.72	380.15	380.36	142527.0
2021-03-03 18:30:00	SPY	ETF	381.42	381.42	379.38	379.43	174933.0
2021-03-03 19:00:00	SPY	ETF	379.48	380.6	379.17	380.24	126880.0
2021-03-03 19:30:00	SPY	ETF	380.26	381.1	380.22	380.91	75593.0
2021-03-03 04:00:00	QQQ	ETF	320.66	321.4	320.66	320.9	30863.0
2021-03-03 04:30:00	QQQ	ETF	320.95	321.11	320.41	320.72	31389.0
2021-03-03 05:00:00	QQQ	ETF	320.61	320.76	320.42	320.6	10926.0
2021-03-03 05:30:00	QQQ	ETF	320.56	320.69	320.01	320.64	19279.0
2021-03-03 06:00:00	QQQ	ETF	320.63	320.64	320.22	320.45	44961.0
2021-03-03 06:30:00	QQQ	ETF	320.48	320.78	320.28	320.65	29279.0
2021-03-03 07:00:00	QQQ	ETF	320.65	320.72	319.85	319.85	212871.0
2021-03-03 07:30:00	QQQ	ETF	319.85	319.97	319.52	319.78	107282.0
2021-03-03 08:00:00	QQQ	ETF	319.81	321.5	318.77	319.12	425617.0
2021-03-03 08:30:00	QQQ	ETF	318.99	319.03	316.27	316.99	966011.0
2021-03-03 09:00:00	QQQ	ETF	316.9	317.38	316.12	317.37	432500.0
2021-03-03 09:30:00	QQQ	ETF	317.3	318.24	314.38	314.69	7893649.0
2021-03-03 10:00:00	QQQ	ETF	314.69	315.1	312.71	313.26	6830819.0
2021-03-03 10:30:00	QQQ	ETF	313.265	314.9302	312.62	314.75	4907756.0
2021-03-03 11:00:00	QQQ	ETF	314.75	316.09	314.41	316.07	3690990.0
2021-03-03 11:30:00	QQQ	ETF	316.04	316.26	314.33	314.38	2719631.0
2021-03-03 12:00:00	QQQ	ETF	314.39	314.7	313.37	313.615	2160872.0
2021-03-03 12:30:00	QQQ	ETF	313.615	313.79	312.48	312.51	3416807.0

> showing 50 of 24,497 rows — these rows as CSV

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