PREVIEW / etf_30min / 2008-03-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-10.parquet
  size:    166 KB
  rows:    5,973

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-03-10 04:00:00	SPY	ETF	129.87	129.87	129.87	129.87	100.0
2008-03-10 04:30:00	SPY	ETF	129.3	129.52	129.3	129.52	200.0
2008-03-10 05:00:00	SPY	ETF	129.36	129.36	129.25	129.25	200.0
2008-03-10 06:00:00	SPY	ETF	129.67	129.67	129.67	129.67	2000.0
2008-03-10 06:30:00	SPY	ETF	129.55	129.82	129.55	129.76	36400.0
2008-03-10 07:00:00	SPY	ETF	129.84	130.26	129.84	130.2	964700.0
2008-03-10 07:30:00	SPY	ETF	130.17	130.17	129.74	129.9	550000.0
2008-03-10 08:00:00	SPY	ETF	129.91	130.19	129.0	129.93	1821400.0
2008-03-10 08:30:00	SPY	ETF	129.91	130.03	129.56	129.86	1127788.0
2008-03-10 09:00:00	SPY	ETF	129.84	129.99	129.35	129.77	934200.0
2008-03-10 09:30:00	SPY	ETF	129.81	129.86	129.1	129.62	18399883.0
2008-03-10 10:00:00	SPY	ETF	129.62	129.93	129.04	129.28	17291122.0
2008-03-10 10:30:00	SPY	ETF	129.27	129.76	129.0	129.4	14008751.0
2008-03-10 11:00:00	SPY	ETF	129.4	129.75	128.72	128.77	16396333.0
2008-03-10 11:30:00	SPY	ETF	128.76	129.32	128.21	128.75	22033281.0
2008-03-10 12:00:00	SPY	ETF	128.76	129.0	128.15	128.6	21548527.0
2008-03-10 12:30:00	SPY	ETF	128.6	129.18	128.5	129.03	11781139.0
2008-03-10 13:00:00	SPY	ETF	129.03	129.12	128.5	128.57	6178606.0
2008-03-10 13:30:00	SPY	ETF	128.57	128.76	128.27	128.3	9676902.0
2008-03-10 14:00:00	SPY	ETF	128.29	128.43	127.59	128.0	21137665.0
2008-03-10 14:30:00	SPY	ETF	128.01	128.4	127.9	127.96	16479710.0
2008-03-10 15:00:00	SPY	ETF	127.97	128.25	127.75	128.2	21818861.0
2008-03-10 15:30:00	SPY	ETF	128.19	128.31	127.63	127.86	26192111.0
2008-03-10 16:00:00	SPY	ETF	127.89	128.18	127.81	127.94	2393900.0
2008-03-10 16:30:00	SPY	ETF	127.93	127.95	127.56	127.75	1172500.0
2008-03-10 17:00:00	SPY	ETF	127.71	127.81	127.67	127.68	287900.0
2008-03-10 17:30:00	SPY	ETF	127.63	128.0	127.61	127.72	103400.0
2008-03-10 18:00:00	SPY	ETF	127.72	128.0	127.66	127.82	53100.0
2008-03-10 18:30:00	SPY	ETF	127.82	127.83	127.76	127.8	48600.0
2008-03-10 19:00:00	SPY	ETF	127.82	127.9	127.79	127.84	11300.0
2008-03-10 19:30:00	SPY	ETF	127.88	127.88	127.75	127.8	4500.0
2008-03-10 04:00:00	QQQ	ETF	41.97	41.97	41.97	41.97	127.0
2008-03-10 05:00:00	QQQ	ETF	41.89	41.89	41.89	41.89	300.0
2008-03-10 06:00:00	QQQ	ETF	42.07	42.07	42.07	42.07	1000.0
2008-03-10 06:30:00	QQQ	ETF	42.18	42.18	42.18	42.18	100.0
2008-03-10 07:00:00	QQQ	ETF	42.14	42.21	42.14	42.2	547400.0
2008-03-10 07:30:00	QQQ	ETF	42.2	42.2	42.06	42.1	155313.0
2008-03-10 08:00:00	QQQ	ETF	42.1	42.12	41.78	42.09	410495.0
2008-03-10 08:30:00	QQQ	ETF	42.11	42.13	41.99	42.03	662529.0
2008-03-10 09:00:00	QQQ	ETF	42.03	42.12	42.0	42.01	1355380.0
2008-03-10 09:30:00	QQQ	ETF	42.01	42.09	41.82	42.01	14767365.0
2008-03-10 10:00:00	QQQ	ETF	42.02	42.14	41.85	41.87	10240218.0
2008-03-10 10:30:00	QQQ	ETF	41.88	42.03	41.84	41.92	11879471.0
2008-03-10 11:00:00	QQQ	ETF	41.92	42.03	41.58	41.6	12810201.0
2008-03-10 11:30:00	QQQ	ETF	41.61	41.7	41.52	41.64	11717306.0
2008-03-10 12:00:00	QQQ	ETF	41.64	41.73	41.47	41.59	14791161.0
2008-03-10 12:30:00	QQQ	ETF	41.58	41.74	41.55	41.71	8091038.0
2008-03-10 13:00:00	QQQ	ETF	41.72	41.74	41.5	41.52	4645761.0
2008-03-10 13:30:00	QQQ	ETF	41.52	41.61	41.43	41.44	5363139.0
2008-03-10 14:00:00	QQQ	ETF	41.4399	41.49	41.21	41.32	10790254.0

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

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