PREVIEW / etf_30min / 2008-10-08

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-08.parquet
  size:    189 KB
  rows:    6,785

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-10-08 04:00:00	SPY	ETF	96.86	97.13	96.4	96.99	10800.0
2008-10-08 04:30:00	SPY	ETF	97.46	98.07	97.0	98.07	4100.0
2008-10-08 05:00:00	SPY	ETF	98.1	98.1	97.58	97.71	5800.0
2008-10-08 05:30:00	SPY	ETF	97.88	97.9	96.86	97.6	37900.0
2008-10-08 06:00:00	SPY	ETF	97.7	99.01	97.52	98.94	55388.0
2008-10-08 06:30:00	SPY	ETF	98.87	99.56	98.43	98.96	591150.0
2008-10-08 07:00:00	SPY	ETF	99.12	104.98	99.12	102.14	5976778.0
2008-10-08 07:30:00	SPY	ETF	102.03	103.15	101.7	103.15	3757304.0
2008-10-08 08:00:00	SPY	ETF	103.14	104.0	97.65	101.59	10687105.0
2008-10-08 08:30:00	SPY	ETF	101.6	101.94	97.81	98.63	19575850.0
2008-10-08 09:00:00	SPY	ETF	98.66	98.66	96.41	97.6	13357414.0
2008-10-08 09:30:00	SPY	ETF	97.52	101.92	96.81	101.17	99634594.0
2008-10-08 10:00:00	SPY	ETF	101.05	102.12	99.14	99.74	55475401.0
2008-10-08 10:30:00	SPY	ETF	99.74	100.45	97.88	98.81	51341825.0
2008-10-08 11:00:00	SPY	ETF	98.81	100.07	98.08	99.25	42973871.0
2008-10-08 11:30:00	SPY	ETF	99.25	99.7725	97.39	98.57	37677607.0
2008-10-08 12:00:00	SPY	ETF	98.56	98.8	97.0	97.29	28404335.0
2008-10-08 12:30:00	SPY	ETF	97.29	99.6272	96.98	97.97	34537364.0
2008-10-08 13:00:00	SPY	ETF	97.97	100.4	97.94	99.16	47976662.0
2008-10-08 13:30:00	SPY	ETF	99.15	101.64	98.84	101.42	46522732.0
2008-10-08 14:00:00	SPY	ETF	101.42	102.18	100.76	101.4	44710476.0
2008-10-08 14:30:00	SPY	ETF	101.38	102.09	100.28	101.21	30901121.0
2008-10-08 15:00:00	SPY	ETF	101.2	102.11	100.24	101.51	43841624.0
2008-10-08 15:30:00	SPY	ETF	101.51	102.17	98.15	98.4	64930265.0
2008-10-08 16:00:00	SPY	ETF	98.35	101.2333	97.0	97.6	22732713.0
2008-10-08 16:30:00	SPY	ETF	97.6	99.6272	96.75	96.9	16837905.0
2008-10-08 17:00:00	SPY	ETF	96.9	99.1	96.75	97.17	949084.0
2008-10-08 17:30:00	SPY	ETF	97.3	97.3	97.1	97.19	77390.0
2008-10-08 18:00:00	SPY	ETF	97.11	97.22	97.06	97.2	289988.0
2008-10-08 18:30:00	SPY	ETF	97.22	97.54	97.15	97.5	103696.0
2008-10-08 19:00:00	SPY	ETF	97.49	97.83	97.49	97.62	60077.0
2008-10-08 19:30:00	SPY	ETF	97.57	97.63	97.15	97.24	63175.0
2008-10-08 04:00:00	QQQ	ETF	31.88	31.88	31.75	31.78	1000.0
2008-10-08 04:30:00	QQQ	ETF	31.87	32.0	31.85	32.0	890.0
2008-10-08 05:00:00	QQQ	ETF	31.89	31.92	31.88	31.92	7700.0
2008-10-08 05:30:00	QQQ	ETF	31.88	31.89	31.6	31.89	11000.0
2008-10-08 06:00:00	QQQ	ETF	31.84	32.14	31.84	32.09	5800.0
2008-10-08 06:30:00	QQQ	ETF	32.12	32.45	32.12	32.24	14100.0
2008-10-08 07:00:00	QQQ	ETF	32.31	34.2	32.31	33.6	2943138.0
2008-10-08 07:30:00	QQQ	ETF	33.62	33.74	32.96	33.39	2259627.0
2008-10-08 08:00:00	QQQ	ETF	33.5729	33.7	32.9	33.0	6483972.0
2008-10-08 08:30:00	QQQ	ETF	32.99	33.05	31.84	32.15	7137898.0
2008-10-08 09:00:00	QQQ	ETF	32.15	32.15	31.35	31.99	4338992.0
2008-10-08 09:30:00	QQQ	ETF	31.99	33.77	31.84	33.46	72438092.0
2008-10-08 10:00:00	QQQ	ETF	33.47	33.89	32.67	32.98	47267546.0
2008-10-08 10:30:00	QQQ	ETF	32.97	33.2	32.38	32.8	36590034.0
2008-10-08 11:00:00	QQQ	ETF	32.81	33.4	32.55	33.16	29808703.0
2008-10-08 11:30:00	QQQ	ETF	33.16	33.27	32.45	32.84	22405092.0
2008-10-08 12:00:00	QQQ	ETF	32.84	32.86	31.99	32.28	24048380.0
2008-10-08 12:30:00	QQQ	ETF	32.3	32.72	32.13	32.64	19216032.0

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

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