PREVIEW / etf_30min / 2008-12-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-03.parquet
  size:    181 KB
  rows:    6,452

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-12-03 04:00:00	SPY	ETF	83.72	83.92	83.69	83.8	3200.0
2008-12-03 04:30:00	SPY	ETF	83.82	83.82	83.82	83.82	600.0
2008-12-03 05:00:00	SPY	ETF	83.89	83.89	83.75	83.82	26700.0
2008-12-03 05:30:00	SPY	ETF	83.82	83.9	83.82	83.9	1500.0
2008-12-03 06:00:00	SPY	ETF	84.21	84.4	83.99	83.99	21529.0
2008-12-03 06:30:00	SPY	ETF	83.81	84.15	83.7	84.09	173155.0
2008-12-03 07:00:00	SPY	ETF	84.2	84.73	84.0	84.57	636249.0
2008-12-03 07:30:00	SPY	ETF	84.55	84.56	83.97	84.12	537570.0
2008-12-03 08:00:00	SPY	ETF	84.11	84.51	83.44	83.49	2361423.0
2008-12-03 08:30:00	SPY	ETF	83.52	83.945	83.39	83.64	2458529.0
2008-12-03 09:00:00	SPY	ETF	83.62	83.66	83.1	83.39	2088727.0
2008-12-03 09:30:00	SPY	ETF	83.4	84.15	83.14	83.49	35658100.0
2008-12-03 10:00:00	SPY	ETF	83.5	84.75	83.14	84.7	37548113.0
2008-12-03 10:30:00	SPY	ETF	84.7	86.23	83.6	86.18	38352146.0
2008-12-03 11:00:00	SPY	ETF	86.18	86.95	85.82	86.1399	32962236.0
2008-12-03 11:30:00	SPY	ETF	86.14	86.94	85.91	86.86	32187103.0
2008-12-03 12:00:00	SPY	ETF	86.86	86.87	85.55	86.01	29819183.0
2008-12-03 12:30:00	SPY	ETF	86.01	86.44	85.81	86.07	18770162.0
2008-12-03 13:00:00	SPY	ETF	86.08	86.14	85.02	85.05	17785616.0
2008-12-03 13:30:00	SPY	ETF	85.07	85.07	83.97	84.23	31277598.0
2008-12-03 14:00:00	SPY	ETF	84.23	85.81	83.9	85.56	49816178.0
2008-12-03 14:30:00	SPY	ETF	85.57	86.63	85.53	85.7612	44812602.0
2008-12-03 15:00:00	SPY	ETF	85.76	86.38	85.18	86.11	42368700.0
2008-12-03 15:30:00	SPY	ETF	86.11	87.83	85.68	87.5	65816609.0
2008-12-03 16:00:00	SPY	ETF	87.49	87.6258	85.3392	87.4	25622375.0
2008-12-03 16:30:00	SPY	ETF	87.36	87.5667	85.3399	87.35	6847165.0
2008-12-03 17:00:00	SPY	ETF	87.34	87.35	87.17	87.17	77515.0
2008-12-03 17:30:00	SPY	ETF	87.16	87.2	85.3392	87.08	1137838.0
2008-12-03 18:00:00	SPY	ETF	87.09	87.39	87.07	87.31	134164.0
2008-12-03 18:30:00	SPY	ETF	87.3	87.3	87.09	87.1	32429.0
2008-12-03 19:00:00	SPY	ETF	87.1	87.16	87.05	87.15	19064.0
2008-12-03 19:30:00	SPY	ETF	87.16	87.16	86.99	87.06	78833.0
2008-12-03 04:00:00	QQQ	ETF	27.39	27.39	27.39	27.39	1150.0
2008-12-03 06:30:00	QQQ	ETF	27.45	27.52	27.4	27.4	15078.0
2008-12-03 07:00:00	QQQ	ETF	27.5	27.58	27.41	27.55	243122.0
2008-12-03 07:30:00	QQQ	ETF	27.51	27.51	27.24	27.25	403429.0
2008-12-03 08:00:00	QQQ	ETF	27.26	27.32	27.14	27.16	810851.0
2008-12-03 08:30:00	QQQ	ETF	27.17	27.29	27.14	27.2	1620396.0
2008-12-03 09:00:00	QQQ	ETF	27.19	27.2	26.99	27.13	1725145.0
2008-12-03 09:30:00	QQQ	ETF	27.13	27.49	27.07	27.33	15184967.0
2008-12-03 10:00:00	QQQ	ETF	27.32	27.8	27.2	27.798	19004414.0
2008-12-03 10:30:00	QQQ	ETF	27.8	28.32	27.78	28.29	19758588.0
2008-12-03 11:00:00	QQQ	ETF	28.29	28.53	28.19	28.24	20424251.0
2008-12-03 11:30:00	QQQ	ETF	28.2405	28.48	28.16	28.4321	12630907.0
2008-12-03 12:00:00	QQQ	ETF	28.44	28.45	28.05	28.18	10453535.0
2008-12-03 12:30:00	QQQ	ETF	28.18	28.35	28.15	28.24	7580892.0
2008-12-03 13:00:00	QQQ	ETF	28.24	28.25	27.86	27.87	7401309.0
2008-12-03 13:30:00	QQQ	ETF	27.86	27.87	27.57	27.65	11347727.0
2008-12-03 14:00:00	QQQ	ETF	27.65	28.09	27.51	28.04	15635100.0
2008-12-03 14:30:00	QQQ	ETF	28.05	28.47	28.04	28.2095	20618630.0

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

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