PREVIEW / etf_30min / 2007-09-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-18.parquet
  size:    131 KB
  rows:    4,868

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-09-18 06:30:00	SPY	ETF	148.34	148.34	148.31	148.31	2100.0
2007-09-18 07:00:00	SPY	ETF	148.3	148.41	148.24	148.26	74800.0
2007-09-18 07:30:00	SPY	ETF	148.29	148.37	148.07	148.18	390800.0
2007-09-18 08:00:00	SPY	ETF	148.2	148.95	148.1	148.76	6373300.0
2007-09-18 08:30:00	SPY	ETF	148.74	149.05	148.59	148.86	2922800.0
2007-09-18 09:00:00	SPY	ETF	148.88	148.96	148.81	148.83	862669.0
2007-09-18 09:30:00	SPY	ETF	148.82	148.95	148.37	148.62	14753628.0
2007-09-18 10:00:00	SPY	ETF	148.62	148.93	148.58	148.91	8247800.0
2007-09-18 10:30:00	SPY	ETF	148.92	149.21	148.83	149.18	14351500.0
2007-09-18 11:00:00	SPY	ETF	149.17	149.57	148.89	149.21	14622100.0
2007-09-18 11:30:00	SPY	ETF	149.22	149.34	148.1341	149.23	8637800.0
2007-09-18 12:00:00	SPY	ETF	149.23	149.3	149.07	149.17	5907900.0
2007-09-18 12:30:00	SPY	ETF	149.17	149.25	149.11	149.17	3259400.0
2007-09-18 13:00:00	SPY	ETF	149.17	149.21	148.95	149.12	5697500.0
2007-09-18 13:30:00	SPY	ETF	149.12	149.2	149.0	149.18	8590000.0
2007-09-18 14:00:00	SPY	ETF	149.19	151.6	148.67	150.55	60700900.0
2007-09-18 14:30:00	SPY	ETF	150.55	151.75	150.55	151.37	33862400.0
2007-09-18 15:00:00	SPY	ETF	151.36	152.07	151.07	152.04	25852500.0
2007-09-18 15:30:00	SPY	ETF	152.04	152.5	151.97	152.4	29954200.0
2007-09-18 16:00:00	SPY	ETF	152.4	152.46	152.2	152.35	11486500.0
2007-09-18 16:30:00	SPY	ETF	152.34	152.53	149.13	152.39	1644800.0
2007-09-18 17:00:00	SPY	ETF	152.37	152.41	152.36	152.37	1104400.0
2007-09-18 17:30:00	SPY	ETF	152.41	152.43	152.3	152.35	551400.0
2007-09-18 18:00:00	SPY	ETF	152.34	152.48	152.32	152.48	66700.0
2007-09-18 18:30:00	SPY	ETF	152.48	152.6	152.48	152.55	44800.0
2007-09-18 19:00:00	SPY	ETF	152.58	152.61	152.46	152.51	352800.0
2007-09-18 19:30:00	SPY	ETF	152.52	152.54	152.47	152.48	18400.0
2007-09-18 06:00:00	QQQ	ETF	48.8	48.8	48.8	48.8	400.0
2007-09-18 06:30:00	QQQ	ETF	48.81	48.81	48.81	48.81	200.0
2007-09-18 07:00:00	QQQ	ETF	48.84	48.86	48.84	48.86	2600.0
2007-09-18 07:30:00	QQQ	ETF	48.85	48.88	48.83	48.84	3087.0
2007-09-18 08:00:00	QQQ	ETF	48.85	49.2	48.84	49.11	2069386.0
2007-09-18 08:30:00	QQQ	ETF	49.09	49.2	49.07	49.11	834743.0
2007-09-18 09:00:00	QQQ	ETF	49.12	49.14	49.08	49.09	437113.0
2007-09-18 09:30:00	QQQ	ETF	49.08	49.1	48.83	48.9	9241222.0
2007-09-18 10:00:00	QQQ	ETF	48.909	49.0	48.88	48.9981	4228805.0
2007-09-18 10:30:00	QQQ	ETF	48.9901	49.03	48.93	49.03	5602150.0
2007-09-18 11:00:00	QQQ	ETF	49.01	49.2	48.97	49.0882	8804314.0
2007-09-18 11:30:00	QQQ	ETF	49.09	49.13	49.04	49.1	3231594.0
2007-09-18 12:00:00	QQQ	ETF	49.1019	49.13	49.03	49.07	2470484.0
2007-09-18 12:30:00	QQQ	ETF	49.068	49.12	49.0501	49.08	1345326.0
2007-09-18 13:00:00	QQQ	ETF	49.08	49.09	48.95	49.032	4527868.0
2007-09-18 13:30:00	QQQ	ETF	49.03	49.05	48.98	49.04	1866019.0
2007-09-18 14:00:00	QQQ	ETF	49.04	52.77	48.91	49.53	29846382.0
2007-09-18 14:30:00	QQQ	ETF	49.53	49.97	49.5215	49.88	21833117.0
2007-09-18 15:00:00	QQQ	ETF	49.86	49.97	49.73	49.92	11751287.0
2007-09-18 15:30:00	QQQ	ETF	49.92	50.08	49.91	50.07	14603485.0
2007-09-18 16:00:00	QQQ	ETF	50.07	50.08	49.0769	50.05	2536270.0
2007-09-18 16:30:00	QQQ	ETF	50.03	50.07	49.56	49.56	239449.0
2007-09-18 17:00:00	QQQ	ETF	50.03	50.04	49.54	50.02	17409.0

> showing 50 of 4,868 rows — these rows as CSV

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