PREVIEW / etf_30min / 2009-12-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-16.parquet
  size:    234 KB
  rows:    7,807

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
2009-12-16 04:00:00	SPY	ETF	111.89	111.94	111.89	111.94	1200.0
2009-12-16 04:30:00	SPY	ETF	111.89	111.89	111.84	111.87	800.0
2009-12-16 05:00:00	SPY	ETF	112.0	112.12	112.0	112.09	2262.0
2009-12-16 05:30:00	SPY	ETF	112.04	112.1	112.03	112.1	3400.0
2009-12-16 06:00:00	SPY	ETF	112.07	112.07	112.02	112.02	6300.0
2009-12-16 06:30:00	SPY	ETF	112.0	112.05	111.9	111.9	7300.0
2009-12-16 07:00:00	SPY	ETF	111.87	111.94	111.87	111.89	79248.0
2009-12-16 07:30:00	SPY	ETF	111.91	111.94	111.83	111.88	146038.0
2009-12-16 08:00:00	SPY	ETF	111.86	112.16	111.73	111.76	428131.0
2009-12-16 08:30:00	SPY	ETF	111.77	111.85	111.76	111.8	860241.0
2009-12-16 09:00:00	SPY	ETF	111.8	111.82	111.69	111.8	653932.0
2009-12-16 09:30:00	SPY	ETF	111.8	112.08	111.76	111.9399	14039378.0
2009-12-16 10:00:00	SPY	ETF	111.93	112.06	111.75	111.82	11311108.0
2009-12-16 10:30:00	SPY	ETF	111.82	112.06	111.81	112.02	8244180.0
2009-12-16 11:00:00	SPY	ETF	112.02	112.13	111.96	112.08	5855589.0
2009-12-16 11:30:00	SPY	ETF	112.09	112.12	111.94	111.96	4541546.0
2009-12-16 12:00:00	SPY	ETF	111.96	112.03	111.88	111.989	6899687.0
2009-12-16 12:30:00	SPY	ETF	111.98	112.0217	111.87	111.8899	3852322.0
2009-12-16 13:00:00	SPY	ETF	111.885	111.97	111.87	111.96	3529317.0
2009-12-16 13:30:00	SPY	ETF	111.95	111.97	111.84	111.84	3766996.0
2009-12-16 14:00:00	SPY	ETF	111.84	112.05	111.63	111.85	24180944.0
2009-12-16 14:30:00	SPY	ETF	111.85	111.89	111.5	111.57	9991474.0
2009-12-16 15:00:00	SPY	ETF	111.57	111.68	111.27	111.29	13730820.0
2009-12-16 15:30:00	SPY	ETF	111.3	111.6	111.28	111.49	14493705.0
2009-12-16 16:00:00	SPY	ETF	111.49	111.99	111.3993	111.49	8409229.0
2009-12-16 16:30:00	SPY	ETF	111.49	111.51	111.2854	111.39	4313055.0
2009-12-16 17:00:00	SPY	ETF	111.37	111.83	111.2854	111.35	4476800.0
2009-12-16 17:30:00	SPY	ETF	111.37	111.44	111.33	111.36	119842.0
2009-12-16 18:00:00	SPY	ETF	111.35	111.44	111.34	111.44	79013.0
2009-12-16 18:30:00	SPY	ETF	111.47	111.5	111.45	111.48	25952.0
2009-12-16 19:00:00	SPY	ETF	111.49	111.55	111.45	111.5	101540.0
2009-12-16 19:30:00	SPY	ETF	111.5	111.58	111.5	111.55	82158.0
2009-12-16 04:00:00	QQQ	ETF	44.5	44.5	44.5	44.5	200.0
2009-12-16 05:00:00	QQQ	ETF	44.55	44.6	44.55	44.59	5300.0
2009-12-16 06:00:00	QQQ	ETF	44.6	44.61	44.58	44.58	8000.0
2009-12-16 06:30:00	QQQ	ETF	44.54	44.54	44.51	44.51	300.0
2009-12-16 07:00:00	QQQ	ETF	44.51	44.55	44.51	44.55	4500.0
2009-12-16 07:30:00	QQQ	ETF	44.53	44.53	44.49	44.49	54100.0
2009-12-16 08:00:00	QQQ	ETF	44.49	44.51	44.43	44.44	158215.0
2009-12-16 08:30:00	QQQ	ETF	44.44	44.51	44.44	44.45	294850.0
2009-12-16 09:00:00	QQQ	ETF	44.44	44.48	44.41	44.47	96418.0
2009-12-16 09:30:00	QQQ	ETF	44.47	44.69	44.46	44.65	10110170.0
2009-12-16 10:00:00	QQQ	ETF	44.66	44.7	44.51	44.5499	8605880.0
2009-12-16 10:30:00	QQQ	ETF	44.55	44.62	44.55	44.571	3958102.0
2009-12-16 11:00:00	QQQ	ETF	44.57	44.64	44.56	44.64	3302990.0
2009-12-16 11:30:00	QQQ	ETF	44.6399	44.65	44.57	44.59	1272902.0
2009-12-16 12:00:00	QQQ	ETF	44.58	44.61	44.56	44.609	1607343.0
2009-12-16 12:30:00	QQQ	ETF	44.6	44.61	44.55	44.55	863215.0
2009-12-16 13:00:00	QQQ	ETF	44.5501	44.59	44.54	44.58	1156986.0
2009-12-16 13:30:00	QQQ	ETF	44.57	44.58	44.44	44.455	2098083.0

> showing 50 of 7,807 rows — these rows as CSV

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