PREVIEW / etf_30min / 2007-03-07

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-07.parquet
  size:    105 KB
  rows:    3,654

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-03-07 04:00:00	SPY	ETF	139.56	139.56	139.56	139.56	1600.0
2007-03-07 06:00:00	SPY	ETF	139.61	139.61	139.5	139.5	7900.0
2007-03-07 06:30:00	SPY	ETF	139.41	139.52	139.39	139.52	20000.0
2007-03-07 07:00:00	SPY	ETF	139.5	139.64	139.5	139.6	66800.0
2007-03-07 07:30:00	SPY	ETF	139.6	139.6	139.42	139.45	428400.0
2007-03-07 08:00:00	SPY	ETF	139.44	139.67	139.43	139.6	671400.0
2007-03-07 08:30:00	SPY	ETF	139.61	139.62	139.49	139.62	703400.0
2007-03-07 09:00:00	SPY	ETF	139.6	139.77	139.32	139.75	2184200.0
2007-03-07 09:30:00	SPY	ETF	139.74	140.05	139.58	139.73	12604300.0
2007-03-07 10:00:00	SPY	ETF	139.73	139.97	139.6	139.91	6785800.0
2007-03-07 10:30:00	SPY	ETF	139.91	140.1	139.71	139.72	8782100.0
2007-03-07 11:00:00	SPY	ETF	139.72	139.73	139.43	139.58	8747800.0
2007-03-07 11:30:00	SPY	ETF	139.57	139.74	139.4	139.7	7185500.0
2007-03-07 12:00:00	SPY	ETF	139.7099	139.86	139.63	139.84	4160200.0
2007-03-07 12:30:00	SPY	ETF	139.84	140.04	139.79	139.94	3990700.0
2007-03-07 13:00:00	SPY	ETF	139.93	140.23	139.81	140.1	6299800.0
2007-03-07 13:30:00	SPY	ETF	140.1	140.46	140.08	140.33	6899400.0
2007-03-07 14:00:00	SPY	ETF	140.33	140.36	140.0	140.17	11671100.0
2007-03-07 14:30:00	SPY	ETF	140.18	140.36	140.13	140.15	6906700.0
2007-03-07 15:00:00	SPY	ETF	140.14	140.37	139.99	139.99	5539100.0
2007-03-07 15:30:00	SPY	ETF	140.0	140.3	139.45	139.46	16567800.0
2007-03-07 16:00:00	SPY	ETF	139.48	139.58	139.43	139.5	1568100.0
2007-03-07 16:30:00	SPY	ETF	139.49	139.52	139.45	139.5	289300.0
2007-03-07 17:00:00	SPY	ETF	139.47	139.53	139.47	139.53	45600.0
2007-03-07 17:30:00	SPY	ETF	139.52	139.54	139.5	139.54	19300.0
2007-03-07 18:00:00	SPY	ETF	139.54	139.54	139.3	139.3	60600.0
2007-03-07 18:30:00	SPY	ETF	139.29	139.35	139.28	139.35	13100.0
2007-03-07 19:00:00	SPY	ETF	139.35	139.56	139.35	139.5	12800.0
2007-03-07 19:30:00	SPY	ETF	139.56	139.58	139.46	139.53	13300.0
2007-03-07 09:00:00	QQQ	ETF	42.86	42.87	42.84	42.85	88688.0
2007-03-07 09:30:00	QQQ	ETF	42.85	42.96	42.71	42.77	18329500.0
2007-03-07 10:00:00	QQQ	ETF	42.77	42.89	42.72	42.86	8670500.0
2007-03-07 10:30:00	QQQ	ETF	42.86	42.89	42.73	42.75	7037300.0
2007-03-07 11:00:00	QQQ	ETF	42.74	42.8	42.65	42.73	8072300.0
2007-03-07 11:30:00	QQQ	ETF	42.73	42.78	42.66	42.78	5101800.0
2007-03-07 12:00:00	QQQ	ETF	42.77	42.86	42.69	42.79	3719000.0
2007-03-07 12:30:00	QQQ	ETF	42.79	42.89	42.66	42.83	10141000.0
2007-03-07 13:00:00	QQQ	ETF	42.83	42.91	42.79	42.88	3800100.0
2007-03-07 13:30:00	QQQ	ETF	42.88	42.98	42.87	42.92	6367600.0
2007-03-07 14:00:00	QQQ	ETF	42.92	42.93	42.79	42.86	9153800.0
2007-03-07 14:30:00	QQQ	ETF	42.87	42.92	42.83	42.87	2955800.0
2007-03-07 15:00:00	QQQ	ETF	42.87	42.94	42.78	42.78	5030500.0
2007-03-07 15:30:00	QQQ	ETF	42.78	42.81	42.66	42.67	14442100.0
2007-03-07 16:00:00	QQQ	ETF	42.67	42.71	42.66	42.68	2194740.0
2007-03-07 16:30:00	QQQ	ETF	42.69	42.7	42.64	42.67	4031940.0
2007-03-07 17:00:00	QQQ	ETF	42.67	42.68	42.66	42.67	33630.0
2007-03-07 17:30:00	QQQ	ETF	42.68	42.68	42.65	42.67	25605.0
2007-03-07 18:00:00	QQQ	ETF	42.66	42.68	42.63	42.63	41990.0
2007-03-07 18:30:00	QQQ	ETF	42.63	42.63	42.61	42.62	24034.0
2007-03-07 19:00:00	QQQ	ETF	42.61	42.68	42.61	42.65	18325.0

> showing 50 of 3,654 rows — these rows as CSV

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