PREVIEW / etf_30min / 2008-10-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-03.parquet
  size:    180 KB
  rows:    6,278

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-03 04:00:00	SPY	ETF	112.55	112.66	112.55	112.66	300.0
2008-10-03 04:30:00	SPY	ETF	112.5	112.5	112.5	112.5	100.0
2008-10-03 05:00:00	SPY	ETF	112.25	112.59	112.25	112.55	900.0
2008-10-03 05:30:00	SPY	ETF	112.51	112.51	112.51	112.51	100.0
2008-10-03 06:00:00	SPY	ETF	112.74	112.74	112.5	112.5	5100.0
2008-10-03 06:30:00	SPY	ETF	112.5	112.7	112.37	112.49	18900.0
2008-10-03 07:00:00	SPY	ETF	112.6	113.16	112.44	112.69	435395.0
2008-10-03 07:30:00	SPY	ETF	112.69	112.7	111.9	112.15	925488.0
2008-10-03 08:00:00	SPY	ETF	112.13	112.61	111.7	112.27	3288126.0
2008-10-03 08:30:00	SPY	ETF	112.06	113.12	111.29	112.76	7571907.0
2008-10-03 09:00:00	SPY	ETF	112.75	113.06	112.54	112.84	1629997.0
2008-10-03 09:30:00	SPY	ETF	112.86	113.74	112.8	113.58	28867792.0
2008-10-03 10:00:00	SPY	ETF	113.58	113.98	112.86	113.76	30164834.0
2008-10-03 10:30:00	SPY	ETF	113.76	114.57	113.6	114.46	26013756.0
2008-10-03 11:00:00	SPY	ETF	114.45	114.96	114.14	114.21	22803438.0
2008-10-03 11:30:00	SPY	ETF	114.21	114.7	113.79	114.12	15445210.0
2008-10-03 12:00:00	SPY	ETF	114.11	114.32	111.3558	113.82	15549958.0
2008-10-03 12:30:00	SPY	ETF	113.82	114.81	113.7	114.8	16223390.0
2008-10-03 13:00:00	SPY	ETF	114.79	115.45	113.12	113.84	42160126.0
2008-10-03 13:30:00	SPY	ETF	113.84	114.37	111.84	112.74	64716457.0
2008-10-03 14:00:00	SPY	ETF	112.74	113.3	111.16	111.38	36945689.0
2008-10-03 14:30:00	SPY	ETF	111.38	112.32	110.57	112.2	47682358.0
2008-10-03 15:00:00	SPY	ETF	112.2	112.7	110.8	111.12	27252076.0
2008-10-03 15:30:00	SPY	ETF	111.12	111.75	109.68	109.97	45607475.0
2008-10-03 16:00:00	SPY	ETF	109.98	114.56	109.92	110.15	18250963.0
2008-10-03 16:30:00	SPY	ETF	110.16	111.3563	109.95	110.27	7354709.0
2008-10-03 17:00:00	SPY	ETF	110.28	110.34	110.15	110.33	435550.0
2008-10-03 17:30:00	SPY	ETF	110.36	110.6	110.3	110.34	76262.0
2008-10-03 18:00:00	SPY	ETF	110.32	110.36	110.2	110.22	19392.0
2008-10-03 18:30:00	SPY	ETF	110.3	110.35	110.21	110.27	19558.0
2008-10-03 19:00:00	SPY	ETF	110.27	110.44	110.25	110.31	6787.0
2008-10-03 19:30:00	SPY	ETF	110.29	110.35	110.27	110.3	5216.0
2008-10-03 04:00:00	QQQ	ETF	37.18	37.18	37.18	37.18	1000.0
2008-10-03 05:00:00	QQQ	ETF	37.1	37.1	37.1	37.1	100.0
2008-10-03 06:00:00	QQQ	ETF	37.18	37.18	37.18	37.18	200.0
2008-10-03 06:30:00	QQQ	ETF	37.09	37.19	37.09	37.11	3100.0
2008-10-03 07:00:00	QQQ	ETF	37.19	37.3	37.19	37.25	53022.0
2008-10-03 07:30:00	QQQ	ETF	37.25	37.25	37.07	37.07	206122.0
2008-10-03 08:00:00	QQQ	ETF	37.07	37.1	36.96	37.01	1366506.0
2008-10-03 08:30:00	QQQ	ETF	37.02	37.39	36.76	37.26	1604213.0
2008-10-03 09:00:00	QQQ	ETF	37.25	37.39	37.19	37.27	788577.0
2008-10-03 09:30:00	QQQ	ETF	37.27	37.67	37.03	37.39	32104149.0
2008-10-03 10:00:00	QQQ	ETF	37.39	37.63	37.25	37.57	14660682.0
2008-10-03 10:30:00	QQQ	ETF	37.58	37.89	37.53	37.8	11879211.0
2008-10-03 11:00:00	QQQ	ETF	37.8	37.97	37.72	37.73	9407576.0
2008-10-03 11:30:00	QQQ	ETF	37.74	37.95	37.68	37.79	7770655.0
2008-10-03 12:00:00	QQQ	ETF	37.78	37.86	37.51	37.69	7839870.0
2008-10-03 12:30:00	QQQ	ETF	37.7	37.96	37.66	37.938	8402695.0
2008-10-03 13:00:00	QQQ	ETF	37.94	38.18	37.33	37.45	28517595.0
2008-10-03 13:30:00	QQQ	ETF	37.4499	37.6	36.58	37.16	41168608.0

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

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