PREVIEW / etf_30min / 2007-11-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-26.parquet
  size:    149 KB
  rows:    5,355

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
2007-11-26 04:00:00	SPY	ETF	145.2	145.2	145.13	145.13	1600.0
2007-11-26 05:00:00	SPY	ETF	144.84	145.0	144.84	145.0	800.0
2007-11-26 05:30:00	SPY	ETF	145.1	145.11	145.1	145.11	2500.0
2007-11-26 06:00:00	SPY	ETF	145.05	145.06	144.85	144.85	22000.0
2007-11-26 06:30:00	SPY	ETF	144.88	144.91	144.79	144.9	31300.0
2007-11-26 07:00:00	SPY	ETF	144.95	144.95	144.65	144.72	275700.0
2007-11-26 07:30:00	SPY	ETF	144.72	144.72	144.45	144.48	751400.0
2007-11-26 08:00:00	SPY	ETF	144.49	145.15	144.4	144.55	1358000.0
2007-11-26 08:30:00	SPY	ETF	144.57	144.62	144.03	144.32	1600500.0
2007-11-26 09:00:00	SPY	ETF	144.32	144.43	144.15	144.37	1250002.0
2007-11-26 09:30:00	SPY	ETF	144.39	144.83	143.91	144.82	24033051.0
2007-11-26 10:00:00	SPY	ETF	144.83	144.88	143.94	143.96	14401462.0
2007-11-26 10:30:00	SPY	ETF	143.94	144.6	143.39	143.42	23681628.0
2007-11-26 11:00:00	SPY	ETF	143.41	143.76	143.18	143.24	12501549.0
2007-11-26 11:30:00	SPY	ETF	143.25	143.61	143.2	143.4	7446392.0
2007-11-26 12:00:00	SPY	ETF	143.4	143.99	143.32	143.93	10479185.0
2007-11-26 12:30:00	SPY	ETF	143.95	144.12	143.69	143.98	8072980.0
2007-11-26 13:00:00	SPY	ETF	143.99	144.12	143.5	143.548	6088000.0
2007-11-26 13:30:00	SPY	ETF	143.54	143.84	143.0	143.19	11225172.0
2007-11-26 14:00:00	SPY	ETF	143.19	143.5	142.89	143.3	10961906.0
2007-11-26 14:30:00	SPY	ETF	143.3	143.45	142.72	142.74	10754564.0
2007-11-26 15:00:00	SPY	ETF	142.74	142.77	141.7	141.77	31657685.0
2007-11-26 15:30:00	SPY	ETF	141.77	142.06	140.78	140.8	24799409.0
2007-11-26 16:00:00	SPY	ETF	140.81	144.94	140.66	140.92	2994400.0
2007-11-26 16:30:00	SPY	ETF	140.91	141.02	140.84	141.0	168700.0
2007-11-26 17:00:00	SPY	ETF	140.98	141.0	140.91	140.91	2901700.0
2007-11-26 17:30:00	SPY	ETF	140.92	140.97	140.88	140.95	1607600.0
2007-11-26 18:00:00	SPY	ETF	140.9	140.9	140.69	140.76	62900.0
2007-11-26 18:30:00	SPY	ETF	140.8	140.9	140.78	140.9	10900.0
2007-11-26 19:00:00	SPY	ETF	140.9	140.93	140.79	140.93	37200.0
2007-11-26 19:30:00	SPY	ETF	140.94	140.95	140.84	140.89	21700.0
2007-11-26 06:30:00	QQQ	ETF	50.1	50.1	50.1	50.1	100.0
2007-11-26 07:00:00	QQQ	ETF	50.1	50.12	50.02	50.07	83183.0
2007-11-26 07:30:00	QQQ	ETF	50.06	50.07	49.98	50.02	378381.0
2007-11-26 08:00:00	QQQ	ETF	50.02	50.3	49.98	50.09	536379.0
2007-11-26 08:30:00	QQQ	ETF	50.08	50.1	49.85	49.94	1199648.0
2007-11-26 09:00:00	QQQ	ETF	49.94	50.0	49.91	49.97	304199.0
2007-11-26 09:30:00	QQQ	ETF	49.98	50.34	49.84	50.34	11778126.0
2007-11-26 10:00:00	QQQ	ETF	50.33	50.37	50.0398	50.05	7051218.0
2007-11-26 10:30:00	QQQ	ETF	50.05	50.19	49.82	49.86	11746466.0
2007-11-26 11:00:00	QQQ	ETF	49.87	50.01	49.59	49.6	9563782.0
2007-11-26 11:30:00	QQQ	ETF	49.6	49.78	49.58	49.69	6872875.0
2007-11-26 12:00:00	QQQ	ETF	49.7	49.97	49.69	49.97	6402316.0
2007-11-26 12:30:00	QQQ	ETF	49.97	50.08	49.92	50.032	5505703.0
2007-11-26 13:00:00	QQQ	ETF	50.0301	50.08	49.89	49.9201	5315584.0
2007-11-26 13:30:00	QQQ	ETF	49.93	50.09	49.71	49.78	8144512.0
2007-11-26 14:00:00	QQQ	ETF	49.78	49.89	49.62	49.79	11350736.0
2007-11-26 14:30:00	QQQ	ETF	49.79	49.93	49.62	49.62	15495514.0
2007-11-26 15:00:00	QQQ	ETF	49.63	49.65	49.17	49.21	22616235.0
2007-11-26 15:30:00	QQQ	ETF	49.22	49.37	48.9	48.95	20178410.0

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

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