PREVIEW / etf_30min / 2020-01-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-06.parquet
  size:    558 KB
  rows:    19,629

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-01-06 04:00:00	SPY	ETF	320.05	320.35	320.0	320.1	27919.0
2020-01-06 04:30:00	SPY	ETF	320.1	320.52	319.98	320.43	12850.0
2020-01-06 05:00:00	SPY	ETF	320.46	320.74	320.46	320.65	15390.0
2020-01-06 05:30:00	SPY	ETF	320.69	320.7	320.45	320.65	8412.0
2020-01-06 06:00:00	SPY	ETF	320.71	320.85	320.55	320.7	10440.0
2020-01-06 06:30:00	SPY	ETF	320.7	320.81	320.57	320.72	89455.0
2020-01-06 07:00:00	SPY	ETF	320.76	321.1	320.76	321.09	232506.0
2020-01-06 07:30:00	SPY	ETF	321.07	321.36	321.0	321.19	145722.0
2020-01-06 08:00:00	SPY	ETF	321.2	321.55	320.06	320.85	325503.0
2020-01-06 08:30:00	SPY	ETF	320.85	320.8798	320.62	320.83	148082.0
2020-01-06 09:00:00	SPY	ETF	320.84	321.02	320.42	320.47	298167.0
2020-01-06 09:30:00	SPY	ETF	320.49	321.75	320.36	321.6	6496255.0
2020-01-06 10:00:00	SPY	ETF	321.595	322.14	321.47	322.09	3575767.0
2020-01-06 10:30:00	SPY	ETF	322.1	322.49	321.88	322.22	2261167.0
2020-01-06 11:00:00	SPY	ETF	322.225	322.51	322.08	322.27	3810273.0
2020-01-06 11:30:00	SPY	ETF	322.27	322.56	322.18	322.27	2026562.0
2020-01-06 12:00:00	SPY	ETF	322.275	322.43	322.14	322.29	1474280.0
2020-01-06 12:30:00	SPY	ETF	322.3	322.5	322.26	322.39	1424069.0
2020-01-06 13:00:00	SPY	ETF	322.39	322.8	322.35	322.8	1946574.0
2020-01-06 13:30:00	SPY	ETF	322.8	322.88	322.6969	322.75	1516185.0
2020-01-06 14:00:00	SPY	ETF	322.745	323.21	322.6	323.06	3052133.0
2020-01-06 14:30:00	SPY	ETF	323.055	323.08	322.9	322.99	1332600.0
2020-01-06 15:00:00	SPY	ETF	323.0	323.2402	322.89	323.06	3133137.0
2020-01-06 15:30:00	SPY	ETF	323.065	323.73	322.92	323.67	11056383.0
2020-01-06 16:00:00	SPY	ETF	323.66	323.95	323.28	323.45	6239837.0
2020-01-06 16:30:00	SPY	ETF	323.47	323.64	323.27	323.27	4213365.0
2020-01-06 17:00:00	SPY	ETF	323.26	323.33	323.23	323.33	86342.0
2020-01-06 17:30:00	SPY	ETF	323.3	323.31	323.15	323.31	43025.0
2020-01-06 18:00:00	SPY	ETF	323.33	323.47	323.27	323.45	48829.0
2020-01-06 18:30:00	SPY	ETF	323.42	323.43	323.21	323.27	13771.0
2020-01-06 19:00:00	SPY	ETF	323.25	323.47	323.25	323.47	15085.0
2020-01-06 19:30:00	SPY	ETF	323.49	323.83	323.49	323.67	76800.0
2020-01-06 04:00:00	QQQ	ETF	212.26	212.52	212.24	212.24	16762.0
2020-01-06 04:30:00	QQQ	ETF	212.21	212.54	212.12	212.5	14803.0
2020-01-06 05:00:00	QQQ	ETF	212.43	212.72	212.41	212.65	15901.0
2020-01-06 05:30:00	QQQ	ETF	212.61	212.72	212.49	212.67	18331.0
2020-01-06 06:00:00	QQQ	ETF	212.67	212.73	212.54	212.67	9680.0
2020-01-06 06:30:00	QQQ	ETF	212.68	212.78	212.57	212.72	16081.0
2020-01-06 07:00:00	QQQ	ETF	212.72	212.96	212.7	212.96	50722.0
2020-01-06 07:30:00	QQQ	ETF	212.94	213.15	212.89	213.01	29022.0
2020-01-06 08:00:00	QQQ	ETF	212.86	213.54	212.29	212.78	152627.0
2020-01-06 08:30:00	QQQ	ETF	212.78	212.82	212.63	212.8	68920.0
2020-01-06 09:00:00	QQQ	ETF	212.77	212.98	212.41	212.46	178528.0
2020-01-06 09:30:00	QQQ	ETF	212.48	213.97	212.24	213.9	3150096.0
2020-01-06 10:00:00	QQQ	ETF	213.92	214.41	213.79	214.39	1721151.0
2020-01-06 10:30:00	QQQ	ETF	214.38	214.7	214.1	214.54	1413222.0
2020-01-06 11:00:00	QQQ	ETF	214.545	214.81	214.4001	214.66	1069048.0
2020-01-06 11:30:00	QQQ	ETF	214.635	214.8427	214.47	214.525	674022.0
2020-01-06 12:00:00	QQQ	ETF	214.53	214.54	214.26	214.46	697406.0
2020-01-06 12:30:00	QQQ	ETF	214.47	214.5599	214.33	214.51	583517.0

> showing 50 of 19,629 rows — these rows as CSV

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