PREVIEW / etf_30min / 2007-12-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-05.parquet
  size:    142 KB
  rows:    5,314

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-12-05 04:00:00	SPY	ETF	147.26	147.26	147.26	147.26	800.0
2007-12-05 05:30:00	SPY	ETF	147.36	147.4	147.36	147.4	5500.0
2007-12-05 06:00:00	SPY	ETF	147.4	147.4	147.24	147.25	6100.0
2007-12-05 06:30:00	SPY	ETF	147.37	147.42	147.36	147.41	57700.0
2007-12-05 07:00:00	SPY	ETF	147.35	147.57	147.35	147.5	244400.0
2007-12-05 07:30:00	SPY	ETF	147.54	147.54	147.27	147.45	133600.0
2007-12-05 08:00:00	SPY	ETF	147.45	147.59	147.27	147.3	3131100.0
2007-12-05 08:30:00	SPY	ETF	147.34	148.19	147.33	148.12	4761000.0
2007-12-05 09:00:00	SPY	ETF	148.11	148.2	146.76	147.92	3222295.0
2007-12-05 09:30:00	SPY	ETF	147.93	148.21	147.83	148.08	12288168.0
2007-12-05 10:00:00	SPY	ETF	148.08	148.37	147.88	148.08	12684909.0
2007-12-05 10:30:00	SPY	ETF	148.08	148.44	147.95	148.3499	7616766.0
2007-12-05 11:00:00	SPY	ETF	148.36	148.93	148.26	148.88	11831021.0
2007-12-05 11:30:00	SPY	ETF	148.87	149.2	148.72	148.88	7156945.0
2007-12-05 12:00:00	SPY	ETF	148.88	148.98	148.72	148.79	5211077.0
2007-12-05 12:30:00	SPY	ETF	148.7999	149.0	148.29	148.48	17366097.0
2007-12-05 13:00:00	SPY	ETF	148.47	148.6	148.09	148.3	14490716.0
2007-12-05 13:30:00	SPY	ETF	148.3	148.78	148.29	148.65	9802342.0
2007-12-05 14:00:00	SPY	ETF	148.66	148.81	148.01	148.13	11238065.0
2007-12-05 14:30:00	SPY	ETF	148.12	148.41	147.86	148.1	12572136.0
2007-12-05 15:00:00	SPY	ETF	148.09	148.68	148.02	148.48	11064937.0
2007-12-05 15:30:00	SPY	ETF	148.49	148.97	148.39	148.86	15801216.0
2007-12-05 16:00:00	SPY	ETF	148.79	148.91	147.96	148.84	1523400.0
2007-12-05 16:30:00	SPY	ETF	148.84	149.07	148.84	149.07	2300700.0
2007-12-05 17:00:00	SPY	ETF	149.07	149.34	148.81	149.34	178200.0
2007-12-05 17:30:00	SPY	ETF	148.48	149.45	148.48	149.25	40200.0
2007-12-05 18:00:00	SPY	ETF	149.32	149.65	149.31	149.65	191700.0
2007-12-05 18:30:00	SPY	ETF	149.58	149.62	149.48	149.5	72700.0
2007-12-05 19:00:00	SPY	ETF	149.51	149.58	149.48	149.57	28200.0
2007-12-05 19:30:00	SPY	ETF	149.56	149.61	149.52	149.61	10600.0
2007-12-05 04:00:00	QQQ	ETF	50.9	50.9	50.9	50.9	200.0
2007-12-05 05:30:00	QQQ	ETF	50.91	50.91	50.91	50.91	10000.0
2007-12-05 07:00:00	QQQ	ETF	50.95	51.02	50.95	50.99	34973.0
2007-12-05 07:30:00	QQQ	ETF	51.0	51.0	50.94	50.98	80100.0
2007-12-05 08:00:00	QQQ	ETF	50.97	51.11	50.674	51.04	2430779.0
2007-12-05 08:30:00	QQQ	ETF	51.03	51.35	51.02	51.33	2371625.0
2007-12-05 09:00:00	QQQ	ETF	51.33	51.33	51.21	51.21	1426042.0
2007-12-05 09:30:00	QQQ	ETF	51.2	51.36	51.16	51.3	16314471.0
2007-12-05 10:00:00	QQQ	ETF	51.308	51.44	51.27	51.39	8996272.0
2007-12-05 10:30:00	QQQ	ETF	51.38	51.63	51.33	51.62	7985984.0
2007-12-05 11:00:00	QQQ	ETF	51.62	51.75	51.52	51.75	10591403.0
2007-12-05 11:30:00	QQQ	ETF	51.75	51.7501	51.66	51.72	4539386.0
2007-12-05 12:00:00	QQQ	ETF	51.72	51.74	51.58	51.63	5991493.0
2007-12-05 12:30:00	QQQ	ETF	51.63	51.77	51.54	51.59	7687227.0
2007-12-05 13:00:00	QQQ	ETF	51.58	52.0	51.49	51.582	11312530.0
2007-12-05 13:30:00	QQQ	ETF	51.59	51.72	51.55	51.68	6148960.0
2007-12-05 14:00:00	QQQ	ETF	51.68	51.75	51.45	51.48	11513268.0
2007-12-05 14:30:00	QQQ	ETF	51.47	51.54	51.32	51.41	14975572.0
2007-12-05 15:00:00	QQQ	ETF	51.41	51.6	51.3699	51.55	7771332.0
2007-12-05 15:30:00	QQQ	ETF	51.55	51.68	51.51	51.63	11260004.0

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

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