PREVIEW / etf_30min / 2007-07-25

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-25.parquet
  size:    129 KB
  rows:    4,774

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-25 04:00:00	SPY	ETF	151.52	151.62	151.37	151.37	14600.0
2007-07-25 04:30:00	SPY	ETF	151.45	151.61	151.45	151.61	3100.0
2007-07-25 05:00:00	SPY	ETF	151.52	151.52	151.52	151.52	2000.0
2007-07-25 05:30:00	SPY	ETF	151.66	151.68	151.66	151.68	4000.0
2007-07-25 06:00:00	SPY	ETF	151.68	151.68	151.68	151.68	1900.0
2007-07-25 06:30:00	SPY	ETF	151.86	151.86	151.77	151.77	25400.0
2007-07-25 07:00:00	SPY	ETF	151.76	152.01	151.73	151.98	484600.0
2007-07-25 07:30:00	SPY	ETF	151.99	152.18	151.99	152.07	810000.0
2007-07-25 08:00:00	SPY	ETF	152.08	152.17	151.63	152.11	3695400.0
2007-07-25 08:30:00	SPY	ETF	152.1	152.22	152.04	152.12	2285600.0
2007-07-25 09:00:00	SPY	ETF	152.12	152.15	151.53	152.03	2298543.0
2007-07-25 09:30:00	SPY	ETF	152.02	152.39	151.99	152.16	19096928.0
2007-07-25 10:00:00	SPY	ETF	152.16	152.25	151.52	151.64	21944105.0
2007-07-25 10:30:00	SPY	ETF	151.64	151.69	150.25	151.14	46951009.0
2007-07-25 11:00:00	SPY	ETF	151.14	151.64	150.74	151.47	30544432.0
2007-07-25 11:30:00	SPY	ETF	151.46	151.82	151.25	151.4525	14912870.0
2007-07-25 12:00:00	SPY	ETF	151.46	151.65	151.17	151.56	8957924.0
2007-07-25 12:30:00	SPY	ETF	151.56	151.68	151.0	151.27	7226763.0
2007-07-25 13:00:00	SPY	ETF	151.27	151.43	150.63	150.64	14513539.0
2007-07-25 13:30:00	SPY	ETF	150.64	151.05	150.4	150.59	13498059.0
2007-07-25 14:00:00	SPY	ETF	150.59	151.27	150.39	151.07	15113487.0
2007-07-25 14:30:00	SPY	ETF	151.07	151.25	150.76	151.18	8876644.0
2007-07-25 15:00:00	SPY	ETF	151.18	152.15	151.12	151.84	26175324.0
2007-07-25 15:30:00	SPY	ETF	151.84	151.9	151.45	151.74	13019355.0
2007-07-25 16:00:00	SPY	ETF	151.73	151.8	151.0576	151.7	5251100.0
2007-07-25 16:30:00	SPY	ETF	151.69	152.24	151.24	151.63	3064900.0
2007-07-25 17:00:00	SPY	ETF	151.65	152.05	151.56	152.05	2909400.0
2007-07-25 17:30:00	SPY	ETF	152.0	152.25	152.0	152.08	85500.0
2007-07-25 18:00:00	SPY	ETF	152.07	152.11	152.01	152.01	425500.0
2007-07-25 18:30:00	SPY	ETF	152.02	152.02	151.91	152.02	26000.0
2007-07-25 19:00:00	SPY	ETF	151.98	151.98	151.95	151.96	11300.0
2007-07-25 19:30:00	SPY	ETF	151.99	151.99	151.95	151.98	1100.0
2007-07-25 04:00:00	QQQ	ETF	49.46	49.46	49.46	49.46	1000.0
2007-07-25 04:30:00	QQQ	ETF	49.5	49.5	49.5	49.5	1000.0
2007-07-25 05:30:00	QQQ	ETF	49.5	49.57	49.5	49.57	6000.0
2007-07-25 06:30:00	QQQ	ETF	49.56	49.56	49.56	49.56	500.0
2007-07-25 07:00:00	QQQ	ETF	49.55	49.65	49.53	49.65	1063348.0
2007-07-25 07:30:00	QQQ	ETF	49.64	49.69	49.62	49.65	931946.0
2007-07-25 08:00:00	QQQ	ETF	49.66	49.67	49.63	49.63	1502427.0
2007-07-25 08:30:00	QQQ	ETF	49.65	49.66	49.6	49.62	456691.0
2007-07-25 09:00:00	QQQ	ETF	49.62	49.62	49.57	49.58	615411.0
2007-07-25 09:30:00	QQQ	ETF	49.57	49.67	49.48	49.63	16801626.0
2007-07-25 10:00:00	QQQ	ETF	49.62	49.64	49.31	49.36	13073692.0
2007-07-25 10:30:00	QQQ	ETF	49.37	49.41	49.06	49.35	22594204.0
2007-07-25 11:00:00	QQQ	ETF	49.34	49.49	49.22	49.42	23519441.0
2007-07-25 11:30:00	QQQ	ETF	49.42	49.49	49.35	49.36	7314978.0
2007-07-25 12:00:00	QQQ	ETF	49.36	49.47	49.3	49.44	3740236.0
2007-07-25 12:30:00	QQQ	ETF	49.44	49.5	49.24	49.35	8209772.0
2007-07-25 13:00:00	QQQ	ETF	49.3495	49.38	49.17	49.2	4680806.0
2007-07-25 13:30:00	QQQ	ETF	49.2	49.28	49.09	49.14	8744441.0

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

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