PREVIEW / etf_30min / 2007-11-13

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-13.parquet
  size:    142 KB
  rows:    5,217

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-13 05:30:00	SPY	ETF	144.53	144.65	144.53	144.65	14300.0
2007-11-13 06:00:00	SPY	ETF	144.65	144.99	144.65	144.99	33100.0
2007-11-13 06:30:00	SPY	ETF	145.04	145.07	144.74	144.74	294800.0
2007-11-13 07:00:00	SPY	ETF	144.73	144.93	144.69	144.81	420700.0
2007-11-13 07:30:00	SPY	ETF	144.8	145.13	144.76	145.06	939000.0
2007-11-13 08:00:00	SPY	ETF	145.06	145.17	144.66	144.96	3247100.0
2007-11-13 08:30:00	SPY	ETF	144.96	145.18	144.88	145.08	1438600.0
2007-11-13 09:00:00	SPY	ETF	145.08	145.44	145.08	145.25	3167224.0
2007-11-13 09:30:00	SPY	ETF	145.26	146.03	145.22	145.59	27527110.0
2007-11-13 10:00:00	SPY	ETF	145.6	146.04	145.48	145.95	16169533.0
2007-11-13 10:30:00	SPY	ETF	145.95	145.97	145.38	145.57	11320711.0
2007-11-13 11:00:00	SPY	ETF	145.57	146.17	145.5	146.14	12808234.0
2007-11-13 11:30:00	SPY	ETF	146.13	146.34	145.84	145.93	9239334.0
2007-11-13 12:00:00	SPY	ETF	145.93	146.1	145.82	145.95	6321663.0
2007-11-13 12:30:00	SPY	ETF	145.95	146.13	145.72	145.86	7101651.0
2007-11-13 13:00:00	SPY	ETF	145.86	146.18	145.65	146.12	6461468.0
2007-11-13 13:30:00	SPY	ETF	146.12	146.71	146.09	146.5	12567142.0
2007-11-13 14:00:00	SPY	ETF	146.49	146.88	146.39	146.66	10471324.0
2007-11-13 14:30:00	SPY	ETF	146.67	147.15	146.62	147.0	9441003.0
2007-11-13 15:00:00	SPY	ETF	147.01	147.62	147.01	147.57	17733949.0
2007-11-13 15:30:00	SPY	ETF	147.57	148.31	147.5	148.2	26057551.0
2007-11-13 16:00:00	SPY	ETF	148.19	148.23	145.22	148.06	3179400.0
2007-11-13 16:30:00	SPY	ETF	148.04	148.06	147.96	148.0	498500.0
2007-11-13 17:00:00	SPY	ETF	148.0	148.02	147.78	147.84	273900.0
2007-11-13 17:30:00	SPY	ETF	147.85	147.9	147.81	147.81	28200.0
2007-11-13 18:00:00	SPY	ETF	147.83	147.93	147.8	147.8	32500.0
2007-11-13 18:30:00	SPY	ETF	147.92	147.92	147.84	147.84	19900.0
2007-11-13 19:00:00	SPY	ETF	147.88	147.88	147.84	147.84	1700.0
2007-11-13 19:30:00	SPY	ETF	147.85	147.99	147.83	147.96	23800.0
2007-11-13 20:00:00	SPY	ETF	147.96	147.96	147.96	147.96	100.0
2007-11-13 04:00:00	QQQ	ETF	48.72	48.72	48.72	48.72	2000.0
2007-11-13 06:00:00	QQQ	ETF	48.93	48.95	48.91	48.91	53500.0
2007-11-13 06:30:00	QQQ	ETF	48.97	49.05	48.9	48.91	20300.0
2007-11-13 07:00:00	QQQ	ETF	48.94	49.02	48.9	48.99	335397.0
2007-11-13 07:30:00	QQQ	ETF	48.99	49.25	48.95	49.23	2370161.0
2007-11-13 08:00:00	QQQ	ETF	49.23	49.36	48.9	49.34	4775738.0
2007-11-13 08:30:00	QQQ	ETF	49.34	49.55	49.33	49.52	2893288.0
2007-11-13 09:00:00	QQQ	ETF	49.5	49.51	49.36	49.39	2839471.0
2007-11-13 09:30:00	QQQ	ETF	49.4	49.67	49.35	49.53	31350021.0
2007-11-13 10:00:00	QQQ	ETF	49.54	49.75	49.5	49.75	14691668.0
2007-11-13 10:30:00	QQQ	ETF	49.75	49.91	49.57	49.835	20165963.0
2007-11-13 11:00:00	QQQ	ETF	49.85	50.07	49.7	50.06	17105141.0
2007-11-13 11:30:00	QQQ	ETF	50.05	50.18	49.7	49.9715	15129378.0
2007-11-13 12:00:00	QQQ	ETF	49.98	50.12	49.88	49.93	15388918.0
2007-11-13 12:30:00	QQQ	ETF	49.93	49.96	49.68	49.75	16290130.0
2007-11-13 13:00:00	QQQ	ETF	49.7499	49.99	49.71	49.96	13338655.0
2007-11-13 13:30:00	QQQ	ETF	49.97	50.21	49.96	50.11	11358932.0
2007-11-13 14:00:00	QQQ	ETF	50.111	50.21	50.02	50.04	9341579.0
2007-11-13 14:30:00	QQQ	ETF	50.0415	50.31	50.04	50.2781	10296664.0
2007-11-13 15:00:00	QQQ	ETF	50.28	50.61	50.28	50.54	31168528.0

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

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