PREVIEW / etf_30min / 2009-01-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-09.parquet
  size:    197 KB
  rows:    6,438

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
2009-01-09 04:00:00	SPY	ETF	90.54	90.69	90.54	90.66	901.0
2009-01-09 04:30:00	SPY	ETF	90.57	90.62	90.52	90.54	1400.0
2009-01-09 05:00:00	SPY	ETF	90.62	90.62	90.62	90.62	200.0
2009-01-09 05:30:00	SPY	ETF	90.7	90.79	90.7	90.79	3300.0
2009-01-09 06:00:00	SPY	ETF	90.85	90.85	90.83	90.83	394.0
2009-01-09 06:30:00	SPY	ETF	90.64	90.65	90.62	90.63	9100.0
2009-01-09 07:00:00	SPY	ETF	90.74	90.89	90.71	90.89	29961.0
2009-01-09 07:30:00	SPY	ETF	90.85	90.9	90.69	90.84	128563.0
2009-01-09 08:00:00	SPY	ETF	90.83	91.0	90.66	90.75	1189231.0
2009-01-09 08:30:00	SPY	ETF	90.8	91.85	90.65	91.45	9762076.0
2009-01-09 09:00:00	SPY	ETF	91.44	91.46	91.1	91.17	1347017.0
2009-01-09 09:30:00	SPY	ETF	91.16	91.32	89.14	89.42	49177633.0
2009-01-09 10:00:00	SPY	ETF	89.4	89.75	89.3	89.39	27354287.0
2009-01-09 10:30:00	SPY	ETF	89.39	89.63	89.03	89.48	22071973.0
2009-01-09 11:00:00	SPY	ETF	89.47	89.94	89.35	89.77	21496080.0
2009-01-09 11:30:00	SPY	ETF	89.77	89.8	89.32	89.57	16990060.0
2009-01-09 12:00:00	SPY	ETF	89.57	89.91	89.46	89.46	15839179.0
2009-01-09 12:30:00	SPY	ETF	89.46	89.71	89.4	89.5	9911214.0
2009-01-09 13:00:00	SPY	ETF	89.51	89.82	89.2	89.44	19286922.0
2009-01-09 13:30:00	SPY	ETF	89.44	89.67	89.27	89.41	11351701.0
2009-01-09 14:00:00	SPY	ETF	89.41	89.96	89.4	89.75	15745016.0
2009-01-09 14:30:00	SPY	ETF	89.75	90.9969	89.73	89.94	18910031.0
2009-01-09 15:00:00	SPY	ETF	89.94	90.12	89.21	89.59	21426007.0
2009-01-09 15:30:00	SPY	ETF	89.59	89.86	88.81	89.01	44514910.0
2009-01-09 16:00:00	SPY	ETF	89.03	89.97	88.67	88.9	9653879.0
2009-01-09 16:30:00	SPY	ETF	88.91	90.9969	88.78	88.85	7629493.0
2009-01-09 17:00:00	SPY	ETF	88.85	88.86	88.75	88.8	79496.0
2009-01-09 17:30:00	SPY	ETF	88.79	88.97	88.74	88.95	118372.0
2009-01-09 18:00:00	SPY	ETF	88.95	89.13	88.91	89.11	127047.0
2009-01-09 18:30:00	SPY	ETF	89.11	89.18	89.04	89.04	109812.0
2009-01-09 19:00:00	SPY	ETF	89.04	89.08	89.01	89.07	15795.0
2009-01-09 19:30:00	SPY	ETF	89.09	89.1	89.02	89.07	18509.0
2009-01-09 04:00:00	QQQ	ETF	30.55	30.55	30.55	30.55	300.0
2009-01-09 04:30:00	QQQ	ETF	30.51	30.51	30.51	30.51	100.0
2009-01-09 06:30:00	QQQ	ETF	30.53	30.55	30.53	30.55	600.0
2009-01-09 07:00:00	QQQ	ETF	30.59	30.59	30.59	30.59	8530.0
2009-01-09 07:30:00	QQQ	ETF	30.65	30.68	30.6	30.66	50736.0
2009-01-09 08:00:00	QQQ	ETF	30.65	30.68	30.56	30.56	481646.0
2009-01-09 08:30:00	QQQ	ETF	30.56	30.9	30.54	30.85	4011951.0
2009-01-09 09:00:00	QQQ	ETF	30.83	30.83	30.75	30.78	642775.0
2009-01-09 09:30:00	QQQ	ETF	30.79	30.79	29.92	29.99	19288735.0
2009-01-09 10:00:00	QQQ	ETF	30.0	30.18	29.97	30.07	11514726.0
2009-01-09 10:30:00	QQQ	ETF	30.06	30.17	29.94	30.1	7307840.0
2009-01-09 11:00:00	QQQ	ETF	30.1	30.28	30.05	30.21	6619405.0
2009-01-09 11:30:00	QQQ	ETF	30.2095	30.22	30.05	30.1701	4476585.0
2009-01-09 12:00:00	QQQ	ETF	30.1701	30.32	30.15	30.1901	4985070.0
2009-01-09 12:30:00	QQQ	ETF	30.19	30.27	30.16	30.18	3703483.0
2009-01-09 13:00:00	QQQ	ETF	30.18	30.3	30.09	30.16	6594203.0
2009-01-09 13:30:00	QQQ	ETF	30.16	30.28	30.1001	30.17	3597046.0
2009-01-09 14:00:00	QQQ	ETF	30.18	30.38	30.17	30.29	4768077.0

> showing 50 of 6,438 rows — these rows as CSV

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