PREVIEW / etf_30min / 2007-01-10

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-10.parquet
  size:    95 KB
  rows:    3,300

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-01-10 04:00:00	SPY	ETF	140.64	140.64	140.64	140.64	1500.0
2007-01-10 06:30:00	SPY	ETF	140.62	140.62	140.62	140.62	1000.0
2007-01-10 07:00:00	SPY	ETF	140.63	140.63	140.5	140.62	245300.0
2007-01-10 07:30:00	SPY	ETF	140.65	140.65	140.55	140.62	115400.0
2007-01-10 08:00:00	SPY	ETF	140.5	140.64	140.46	140.51	1033400.0
2007-01-10 08:30:00	SPY	ETF	140.56	140.64	140.42	140.62	655100.0
2007-01-10 09:00:00	SPY	ETF	140.62	140.62	140.53	140.6	1157300.0
2007-01-10 09:30:00	SPY	ETF	140.58	140.72	140.3	140.6	8789600.0
2007-01-10 10:00:00	SPY	ETF	140.6	140.99	140.56	140.76	7559500.0
2007-01-10 10:30:00	SPY	ETF	140.76	141.06	140.64	140.94	5678900.0
2007-01-10 11:00:00	SPY	ETF	140.93	140.94	140.66	140.69	2563600.0
2007-01-10 11:30:00	SPY	ETF	140.69	140.91	140.6	140.85	2689900.0
2007-01-10 12:00:00	SPY	ETF	140.86	140.91	140.69	140.7	1722800.0
2007-01-10 12:30:00	SPY	ETF	140.7	140.99	140.59	140.89	4643700.0
2007-01-10 13:00:00	SPY	ETF	140.91	141.1	140.85	141.05	2719000.0
2007-01-10 13:30:00	SPY	ETF	141.05	141.35	140.91	141.19	9269400.0
2007-01-10 14:00:00	SPY	ETF	141.2	141.38	141.15	141.18	4046800.0
2007-01-10 14:30:00	SPY	ETF	141.18	141.42	141.11	141.29	3609500.0
2007-01-10 15:00:00	SPY	ETF	141.28	141.43	141.1081	141.4	4168000.0
2007-01-10 15:30:00	SPY	ETF	141.4	141.53	141.3	141.4	5115700.0
2007-01-10 16:00:00	SPY	ETF	141.39	141.6	141.39	141.54	1127100.0
2007-01-10 16:30:00	SPY	ETF	141.55	141.7	141.55	141.68	376200.0
2007-01-10 17:00:00	SPY	ETF	141.67	141.7	141.63	141.63	82700.0
2007-01-10 17:30:00	SPY	ETF	141.63	141.67	141.61	141.67	22700.0
2007-01-10 18:30:00	SPY	ETF	141.65	141.66	141.57	141.57	41700.0
2007-01-10 19:00:00	SPY	ETF	141.6	141.63	141.57	141.63	13500.0
2007-01-10 19:30:00	SPY	ETF	141.61	141.61	141.61	141.61	1000.0
2007-01-10 04:00:00	QQQ	ETF	43.93	43.93	43.93	43.93	100.0
2007-01-10 06:30:00	QQQ	ETF	43.81	43.84	43.79	43.82	325000.0
2007-01-10 07:00:00	QQQ	ETF	43.86	43.88	43.8	43.88	84230.0
2007-01-10 07:30:00	QQQ	ETF	43.88	43.89	43.85	43.89	154600.0
2007-01-10 08:00:00	QQQ	ETF	43.89	43.92	43.88	43.9	366636.0
2007-01-10 08:30:00	QQQ	ETF	43.91	43.96	43.8	43.95	663121.0
2007-01-10 09:00:00	QQQ	ETF	43.95	43.97	43.92	43.95	409024.0
2007-01-10 09:30:00	QQQ	ETF	43.96	44.1	43.82	44.07	17666200.0
2007-01-10 10:00:00	QQQ	ETF	44.08	44.21	44.01	44.15	16572200.0
2007-01-10 10:30:00	QQQ	ETF	44.15	44.36	44.11	44.34	12876600.0
2007-01-10 11:00:00	QQQ	ETF	44.33	44.34	44.2	44.21	5123500.0
2007-01-10 11:30:00	QQQ	ETF	44.21	44.34	44.16	44.3	4556800.0
2007-01-10 12:00:00	QQQ	ETF	44.3	44.32	44.23	44.25	2266200.0
2007-01-10 12:30:00	QQQ	ETF	44.25	44.33	44.2	44.33	3210400.0
2007-01-10 13:00:00	QQQ	ETF	44.32	44.43	44.3	44.41	5008000.0
2007-01-10 13:30:00	QQQ	ETF	44.42	44.5	44.36	44.41	6313800.0
2007-01-10 14:00:00	QQQ	ETF	44.41	44.52	44.32	44.45	4736100.0
2007-01-10 14:30:00	QQQ	ETF	44.45	44.59	44.32	44.5	5937600.0
2007-01-10 15:00:00	QQQ	ETF	44.5	44.6	44.49	44.57	4652500.0
2007-01-10 15:30:00	QQQ	ETF	44.57	44.66	44.52	44.64	8053500.0
2007-01-10 16:00:00	QQQ	ETF	44.64	44.74	44.615	44.73	3862024.0
2007-01-10 16:30:00	QQQ	ETF	44.73	44.81	44.71	44.81	1366293.0
2007-01-10 17:00:00	QQQ	ETF	44.8	44.81	44.73	44.76	403674.0

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

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