PREVIEW / etf_30min / 2008-02-20

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-20.parquet
  size:    159 KB
  rows:    5,681

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
2008-02-20 04:00:00	SPY	ETF	134.81	134.87	134.81	134.87	200.0
2008-02-20 04:30:00	SPY	ETF	135.06	135.06	135.06	135.06	100.0
2008-02-20 05:30:00	SPY	ETF	134.99	134.99	134.8	134.81	6600.0
2008-02-20 06:00:00	SPY	ETF	134.73	134.83	134.73	134.77	34200.0
2008-02-20 06:30:00	SPY	ETF	134.76	134.77	134.6	134.67	23000.0
2008-02-20 07:00:00	SPY	ETF	134.6	134.65	134.12	134.37	783400.0
2008-02-20 07:30:00	SPY	ETF	134.48	134.51	134.35	134.42	548900.0
2008-02-20 08:00:00	SPY	ETF	134.42	135.4	134.16	134.39	2260000.0
2008-02-20 08:30:00	SPY	ETF	134.38	134.49	133.5	133.81	6029200.0
2008-02-20 09:00:00	SPY	ETF	133.82	134.38	133.61	134.01	1420725.0
2008-02-20 09:30:00	SPY	ETF	133.99	134.47	133.84	134.14	23377088.0
2008-02-20 10:00:00	SPY	ETF	134.14	134.56	133.76	134.35	16696557.0
2008-02-20 10:30:00	SPY	ETF	134.36	134.62	134.14	134.19	13383095.0
2008-02-20 11:00:00	SPY	ETF	134.19	134.56	134.0	134.43	6380380.0
2008-02-20 11:30:00	SPY	ETF	134.42	134.45	134.18	134.33	4036733.0
2008-02-20 12:00:00	SPY	ETF	134.34	135.98	134.22	135.28	30627238.0
2008-02-20 12:30:00	SPY	ETF	135.29	135.47	135.15	135.2	8547048.0
2008-02-20 13:00:00	SPY	ETF	135.2	135.9	135.15	135.26	11991014.0
2008-02-20 13:30:00	SPY	ETF	135.27	135.74	135.04	135.46	10336020.0
2008-02-20 14:00:00	SPY	ETF	135.45	137.6	135.0	135.4425	24160441.0
2008-02-20 14:30:00	SPY	ETF	135.44	136.55	135.32	136.34	20661192.0
2008-02-20 15:00:00	SPY	ETF	136.34	136.43	135.77	135.83	13189158.0
2008-02-20 15:30:00	SPY	ETF	135.84	136.19	135.65	136.11	22400499.0
2008-02-20 16:00:00	SPY	ETF	136.09	136.14	135.9	135.9	1669200.0
2008-02-20 16:30:00	SPY	ETF	135.92	135.97	135.86	135.96	229700.0
2008-02-20 17:00:00	SPY	ETF	135.96	136.03	135.91	135.97	35100.0
2008-02-20 17:30:00	SPY	ETF	135.95	136.08	135.95	136.06	173100.0
2008-02-20 18:00:00	SPY	ETF	136.05	136.19	136.05	136.15	45700.0
2008-02-20 18:30:00	SPY	ETF	136.15	136.2	136.14	136.17	22500.0
2008-02-20 19:00:00	SPY	ETF	136.19	136.2	136.11	136.2	4700.0
2008-02-20 19:30:00	SPY	ETF	136.22	136.4	136.22	136.24	28000.0
2008-02-20 04:00:00	QQQ	ETF	43.45	43.45	43.45	43.45	100.0
2008-02-20 05:00:00	QQQ	ETF	43.58	43.58	43.58	43.58	800.0
2008-02-20 06:00:00	QQQ	ETF	43.51	43.52	43.5	43.52	10500.0
2008-02-20 06:30:00	QQQ	ETF	43.48	43.5	43.48	43.5	10400.0
2008-02-20 07:00:00	QQQ	ETF	43.48	43.48	43.31	43.38	382350.0
2008-02-20 07:30:00	QQQ	ETF	43.39	43.42	43.35	43.37	180018.0
2008-02-20 08:00:00	QQQ	ETF	43.38	43.48	43.33	43.42	902492.0
2008-02-20 08:30:00	QQQ	ETF	43.34	43.43	43.05	43.1	2263915.0
2008-02-20 09:00:00	QQQ	ETF	43.1	43.27	43.09	43.26	1004755.0
2008-02-20 09:30:00	QQQ	ETF	43.25	43.51	43.24	43.37	13081706.0
2008-02-20 10:00:00	QQQ	ETF	43.38	43.6	43.24	43.47	18451495.0
2008-02-20 10:30:00	QQQ	ETF	43.47	43.52	43.32	43.36	6052037.0
2008-02-20 11:00:00	QQQ	ETF	43.36	43.42	43.3	43.39	3236825.0
2008-02-20 11:30:00	QQQ	ETF	43.39	43.39	43.26	43.3385	2865207.0
2008-02-20 12:00:00	QQQ	ETF	43.34	43.87	43.32	43.772	15467972.0
2008-02-20 12:30:00	QQQ	ETF	43.78	43.81	43.6	43.645	6990094.0
2008-02-20 13:00:00	QQQ	ETF	43.6495	43.91	43.6	43.64	7962624.0
2008-02-20 13:30:00	QQQ	ETF	43.64	43.86	43.56	43.78	7375638.0
2008-02-20 14:00:00	QQQ	ETF	43.78	43.89	43.56	43.72	14234332.0

> showing 50 of 5,681 rows — these rows as CSV

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