PREVIEW / etf_30min / 2008-01-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-29.parquet
  size:    149 KB
  rows:    5,528

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-01-29 04:30:00	SPY	ETF	135.29	135.29	135.29	135.29	100.0
2008-01-29 05:30:00	SPY	ETF	135.41	135.66	135.41	135.66	200.0
2008-01-29 06:00:00	SPY	ETF	135.89	135.89	135.89	135.89	25000.0
2008-01-29 06:30:00	SPY	ETF	135.56	135.72	135.56	135.72	9000.0
2008-01-29 07:00:00	SPY	ETF	135.57	135.72	135.44	135.65	166100.0
2008-01-29 07:30:00	SPY	ETF	135.65	135.8	135.47	135.59	394100.0
2008-01-29 08:00:00	SPY	ETF	135.59	135.93	135.07	135.76	1740600.0
2008-01-29 08:30:00	SPY	ETF	135.82	136.35	135.82	136.11	5124100.0
2008-01-29 09:00:00	SPY	ETF	136.12	136.36	136.04	136.13	1522000.0
2008-01-29 09:30:00	SPY	ETF	136.1	136.3	135.2	135.24	21401515.0
2008-01-29 10:00:00	SPY	ETF	135.25	135.98	134.88	135.89	19759818.0
2008-01-29 10:30:00	SPY	ETF	135.88	135.95	135.48	135.73	10142840.0
2008-01-29 11:00:00	SPY	ETF	135.73	136.32	135.7	135.93	10676946.0
2008-01-29 11:30:00	SPY	ETF	135.94	136.25	135.85	136.03	6376398.0
2008-01-29 12:00:00	SPY	ETF	136.02	136.0599	135.32	135.5	9409244.0
2008-01-29 12:30:00	SPY	ETF	135.5	135.74	135.34	135.5374	6236581.0
2008-01-29 13:00:00	SPY	ETF	135.53	135.75	135.35	135.708	11911396.0
2008-01-29 13:30:00	SPY	ETF	135.69	135.95	135.5	135.57	6563270.0
2008-01-29 14:00:00	SPY	ETF	135.5699	135.82	135.38	135.77	7773169.0
2008-01-29 14:30:00	SPY	ETF	135.77	135.96	135.56	135.85	7870333.0
2008-01-29 15:00:00	SPY	ETF	135.86	136.45	135.84	136.22	12402532.0
2008-01-29 15:30:00	SPY	ETF	136.225	136.34	135.94	136.07	17836289.0
2008-01-29 16:00:00	SPY	ETF	135.98	136.22	135.3169	135.88	2990600.0
2008-01-29 16:30:00	SPY	ETF	135.95	136.04	135.8	135.91	2196060.0
2008-01-29 17:00:00	SPY	ETF	135.91	135.96	135.32	135.96	4063500.0
2008-01-29 17:30:00	SPY	ETF	135.97	135.97	135.88	135.9	144800.0
2008-01-29 18:00:00	SPY	ETF	135.9	135.94	135.87	135.89	68200.0
2008-01-29 18:30:00	SPY	ETF	135.91	135.91	135.81	135.81	49200.0
2008-01-29 19:00:00	SPY	ETF	135.82	135.85	135.75	135.8	30100.0
2008-01-29 19:30:00	SPY	ETF	135.78	135.79	135.69	135.74	12000.0
2008-01-29 06:30:00	QQQ	ETF	44.52	44.54	44.52	44.54	25000.0
2008-01-29 07:00:00	QQQ	ETF	44.4	44.48	44.4	44.48	67100.0
2008-01-29 07:30:00	QQQ	ETF	44.44	44.47	44.35	44.35	84418.0
2008-01-29 08:00:00	QQQ	ETF	44.41	44.52	44.22	44.51	481975.0
2008-01-29 08:30:00	QQQ	ETF	44.51	44.69	44.51	44.65	2205296.0
2008-01-29 09:00:00	QQQ	ETF	44.65	44.72	44.57	44.57	717079.0
2008-01-29 09:30:00	QQQ	ETF	44.57	44.68	44.21	44.22	24238537.0
2008-01-29 10:00:00	QQQ	ETF	44.22	44.47	44.04	44.42	21697019.0
2008-01-29 10:30:00	QQQ	ETF	44.42	44.45	44.22	44.295	8113582.0
2008-01-29 11:00:00	QQQ	ETF	44.29	44.47	44.29	44.37	6594575.0
2008-01-29 11:30:00	QQQ	ETF	44.38	44.49	44.37	44.43	6626354.0
2008-01-29 12:00:00	QQQ	ETF	44.42	44.43	44.12	44.19	9520829.0
2008-01-29 12:30:00	QQQ	ETF	44.1896	44.29	44.13	44.2101	8558762.0
2008-01-29 13:00:00	QQQ	ETF	44.2199	44.32	44.15	44.3099	5471009.0
2008-01-29 13:30:00	QQQ	ETF	44.31	44.38	44.25	44.27	4659238.0
2008-01-29 14:00:00	QQQ	ETF	44.28	44.39	44.18	44.35	6046471.0
2008-01-29 14:30:00	QQQ	ETF	44.36	44.44	44.18	44.39	9720813.0
2008-01-29 15:00:00	QQQ	ETF	44.3905	44.55	44.38	44.49	8551149.0
2008-01-29 15:30:00	QQQ	ETF	44.49	44.51	44.35	44.44	12127242.0
2008-01-29 16:00:00	QQQ	ETF	44.41	44.44	44.36	44.4	1113352.0

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

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