PREVIEW / etf_30min / 2007-07-26

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-26.parquet
  size:    148 KB
  rows:    5,306

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-07-26 04:30:00	SPY	ETF	151.16	151.29	151.16	151.25	6300.0
2007-07-26 05:30:00	SPY	ETF	151.36	151.36	151.36	151.36	6000.0
2007-07-26 06:00:00	SPY	ETF	151.1	151.25	150.96	151.25	206300.0
2007-07-26 06:30:00	SPY	ETF	151.07	151.17	150.96	150.97	111000.0
2007-07-26 07:00:00	SPY	ETF	150.94	151.02	150.3	150.48	2221700.0
2007-07-26 07:30:00	SPY	ETF	150.51	150.52	149.77	150.3	2792700.0
2007-07-26 08:00:00	SPY	ETF	150.35	151.0	150.0	150.44	9818300.0
2007-07-26 08:30:00	SPY	ETF	150.44	150.44	149.87	149.88	10501500.0
2007-07-26 09:00:00	SPY	ETF	150.11	150.34	149.9	150.13	3635935.0
2007-07-26 09:30:00	SPY	ETF	150.19	150.44	149.53	150.2	38133140.0
2007-07-26 10:00:00	SPY	ETF	150.2	150.8	149.65	150.1	28375591.0
2007-07-26 10:30:00	SPY	ETF	150.11	150.34	149.78	150.09	14968295.0
2007-07-26 11:00:00	SPY	ETF	150.09	150.09	148.79	148.995	31326168.0
2007-07-26 11:30:00	SPY	ETF	149.0	149.4	148.33	149.23	33247944.0
2007-07-26 12:00:00	SPY	ETF	149.24	149.4	148.59	148.67	25042555.0
2007-07-26 12:30:00	SPY	ETF	148.67	148.81	147.67	148.53	31410357.0
2007-07-26 13:00:00	SPY	ETF	148.53	148.98	148.07	148.27	23583027.0
2007-07-26 13:30:00	SPY	ETF	148.26	148.6	147.54	147.73	21432253.0
2007-07-26 14:00:00	SPY	ETF	147.73	148.09	146.62	147.03	32499017.0
2007-07-26 14:30:00	SPY	ETF	147.03	147.72	146.39	147.14	38399453.0
2007-07-26 15:00:00	SPY	ETF	147.14	148.8	146.97	147.91	44000917.0
2007-07-26 15:30:00	SPY	ETF	147.91	148.68	147.0	148.54	44691941.0
2007-07-26 16:00:00	SPY	ETF	148.51	148.67	147.87	148.35	10742600.0
2007-07-26 16:30:00	SPY	ETF	148.28	148.37	148.12	148.24	2692900.0
2007-07-26 17:00:00	SPY	ETF	148.27	148.62	148.1	148.32	1868100.0
2007-07-26 17:30:00	SPY	ETF	148.2	148.35	148.12	148.32	286200.0
2007-07-26 18:00:00	SPY	ETF	148.35	148.39	148.04	148.1	2248600.0
2007-07-26 18:30:00	SPY	ETF	148.07	148.32	148.07	148.28	39000.0
2007-07-26 19:00:00	SPY	ETF	148.28	148.32	147.42	147.6	41000.0
2007-07-26 19:30:00	SPY	ETF	148.23	148.26	148.03	148.03	73800.0
2007-07-26 04:00:00	QQQ	ETF	49.59	49.61	49.58	49.58	2900.0
2007-07-26 06:30:00	QQQ	ETF	49.47	49.47	49.3	49.3	411700.0
2007-07-26 07:00:00	QQQ	ETF	49.3	49.3	49.09	49.15	781178.0
2007-07-26 07:30:00	QQQ	ETF	49.17	49.19	48.88	49.1	1324239.0
2007-07-26 08:00:00	QQQ	ETF	49.12	49.22	49.08	49.15	971929.0
2007-07-26 08:30:00	QQQ	ETF	49.15	49.17	48.93	48.98	5741438.0
2007-07-26 09:00:00	QQQ	ETF	48.97	49.1	48.93	49.07	1169516.0
2007-07-26 09:30:00	QQQ	ETF	49.07	49.28	48.96	49.25	22578541.0
2007-07-26 10:00:00	QQQ	ETF	49.26	49.47	49.17	49.33	22531143.0
2007-07-26 10:30:00	QQQ	ETF	49.34	49.42	49.21	49.35	8745200.0
2007-07-26 11:00:00	QQQ	ETF	49.3405	49.92	48.83	48.92	26178690.0
2007-07-26 11:30:00	QQQ	ETF	48.92	49.07	48.78	49.05	18586858.0
2007-07-26 12:00:00	QQQ	ETF	49.0501	49.08	48.73	48.79	17045574.0
2007-07-26 12:30:00	QQQ	ETF	48.8	48.83	48.4201	48.69	27774905.0
2007-07-26 13:00:00	QQQ	ETF	48.69	48.81	48.52	48.6	18163013.0
2007-07-26 13:30:00	QQQ	ETF	48.6	48.72	48.38	48.4	19509529.0
2007-07-26 14:00:00	QQQ	ETF	48.4	48.51	48.09	48.23	24036258.0
2007-07-26 14:30:00	QQQ	ETF	48.2301	48.43	48.05	48.335	20899941.0
2007-07-26 15:00:00	QQQ	ETF	48.335	48.78	48.25	48.51	21936561.0
2007-07-26 15:30:00	QQQ	ETF	48.51	48.98	48.42	48.97	39023116.0

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

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