PREVIEW / etf_30min / 2009-12-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-30.parquet
  size:    225 KB
  rows:    7,624

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-30 04:00:00	SPY	ETF	112.29	112.29	112.29	112.29	200.0
2009-12-30 04:30:00	SPY	ETF	112.23	112.23	111.92	112.03	5156.0
2009-12-30 05:00:00	SPY	ETF	111.99	111.99	111.9	111.9	2300.0
2009-12-30 05:30:00	SPY	ETF	112.0	112.0	112.0	112.0	2100.0
2009-12-30 06:00:00	SPY	ETF	111.75	111.82	111.75	111.82	200.0
2009-12-30 06:30:00	SPY	ETF	111.91	111.91	111.88	111.88	3100.0
2009-12-30 07:00:00	SPY	ETF	111.87	112.02	111.87	112.0	119565.0
2009-12-30 07:30:00	SPY	ETF	112.05	112.19	112.01	112.12	251572.0
2009-12-30 08:00:00	SPY	ETF	112.11	112.17	112.09	112.13	330095.0
2009-12-30 08:30:00	SPY	ETF	112.14	112.21	112.11	112.2	281812.0
2009-12-30 09:00:00	SPY	ETF	112.21	112.22	112.11	112.22	736919.0
2009-12-30 09:30:00	SPY	ETF	112.23	112.65	112.17	112.54	15029778.0
2009-12-30 10:00:00	SPY	ETF	112.55	112.64	112.45	112.48	6604208.0
2009-12-30 10:30:00	SPY	ETF	112.48	112.53	112.25	112.34	4693902.0
2009-12-30 11:00:00	SPY	ETF	112.34	112.45	112.23	112.25	3867857.0
2009-12-30 11:30:00	SPY	ETF	112.25	112.51	112.21	112.4701	4325893.0
2009-12-30 12:00:00	SPY	ETF	112.48	112.56	112.2	112.5201	3687921.0
2009-12-30 12:30:00	SPY	ETF	112.52	112.525	112.33	112.39	2859638.0
2009-12-30 13:00:00	SPY	ETF	112.4	112.5	112.3	112.3115	3551732.0
2009-12-30 13:30:00	SPY	ETF	112.32	112.38	112.27	112.37	2078880.0
2009-12-30 14:00:00	SPY	ETF	112.37	112.41	112.36	112.3799	2039725.0
2009-12-30 14:30:00	SPY	ETF	112.37	112.54	112.37	112.502	2464813.0
2009-12-30 15:00:00	SPY	ETF	112.5	112.51	112.37	112.44	3345486.0
2009-12-30 15:30:00	SPY	ETF	112.44	112.62	112.43	112.55	8094158.0
2009-12-30 16:00:00	SPY	ETF	112.52	112.64	112.23	112.6	4102249.0
2009-12-30 16:30:00	SPY	ETF	112.57	112.67	112.4	112.67	2244144.0
2009-12-30 17:00:00	SPY	ETF	112.67	112.69	112.45	112.64	836819.0
2009-12-30 17:30:00	SPY	ETF	112.66	112.69	112.64	112.66	25125.0
2009-12-30 18:00:00	SPY	ETF	112.66	112.69	112.64	112.69	37840.0
2009-12-30 18:30:00	SPY	ETF	112.68	112.69	112.6	112.6	89030.0
2009-12-30 19:00:00	SPY	ETF	112.61	112.67	112.57	112.67	28789.0
2009-12-30 19:30:00	SPY	ETF	112.67	112.71	112.65	112.7	12722.0
2009-12-30 05:00:00	QQQ	ETF	45.86	45.86	45.86	45.86	300.0
2009-12-30 06:30:00	QQQ	ETF	45.87	45.9	45.84	45.84	24718.0
2009-12-30 07:00:00	QQQ	ETF	45.89	45.94	45.89	45.91	12000.0
2009-12-30 07:30:00	QQQ	ETF	45.92	45.98	45.92	45.94	7687.0
2009-12-30 08:00:00	QQQ	ETF	45.94	45.96	45.88	45.95	91826.0
2009-12-30 08:30:00	QQQ	ETF	45.94	45.97	45.93	45.95	139517.0
2009-12-30 09:00:00	QQQ	ETF	45.95	46.0	45.94	45.99	313795.0
2009-12-30 09:30:00	QQQ	ETF	46.0	46.26	45.971	46.19	13383852.0
2009-12-30 10:00:00	QQQ	ETF	46.2	46.23	46.11	46.1126	4462036.0
2009-12-30 10:30:00	QQQ	ETF	46.12	46.13	45.97	46.0101	3848556.0
2009-12-30 11:00:00	QQQ	ETF	46.01	46.05	45.96	45.98	2425431.0
2009-12-30 11:30:00	QQQ	ETF	45.98	46.12	45.96	46.0899	4101670.0
2009-12-30 12:00:00	QQQ	ETF	46.09	46.13	46.085	46.1217	1663610.0
2009-12-30 12:30:00	QQQ	ETF	46.12	46.14	46.06	46.09	2207810.0
2009-12-30 13:00:00	QQQ	ETF	46.08	46.13	46.02	46.03	3907515.0
2009-12-30 13:30:00	QQQ	ETF	46.04	46.09	46.0	46.08	4229635.0
2009-12-30 14:00:00	QQQ	ETF	46.09	46.1	46.05	46.07	2813548.0
2009-12-30 14:30:00	QQQ	ETF	46.08	46.15	46.075	46.12	1058494.0

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

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