PREVIEW / etf_30min / 2007-01-05

all etf 30-min files

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

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-05 04:00:00	SPY	ETF	141.31	141.31	141.31	141.31	100.0
2007-01-05 04:30:00	SPY	ETF	141.35	141.35	141.35	141.35	1500.0
2007-01-05 07:00:00	SPY	ETF	141.36	141.36	141.24	141.28	12800.0
2007-01-05 07:30:00	SPY	ETF	141.25	141.25	141.01	141.01	263900.0
2007-01-05 08:00:00	SPY	ETF	141.1	141.36	140.98	141.04	1303700.0
2007-01-05 08:30:00	SPY	ETF	141.19	141.49	141.03	141.25	4394700.0
2007-01-05 09:00:00	SPY	ETF	141.25	141.4	141.18	141.33	256400.0
2007-01-05 09:30:00	SPY	ETF	141.33	141.4	140.8	140.89	8942400.0
2007-01-05 10:00:00	SPY	ETF	140.93	141.32	140.86	141.16	9234300.0
2007-01-05 10:30:00	SPY	ETF	141.16	141.26	140.97	140.98	3566400.0
2007-01-05 11:00:00	SPY	ETF	140.98	141.11	140.41	140.44	10785100.0
2007-01-05 11:30:00	SPY	ETF	140.44	140.69	140.38	140.6611	6973600.0
2007-01-05 12:00:00	SPY	ETF	140.66	140.85	140.64	140.78	2856500.0
2007-01-05 12:30:00	SPY	ETF	140.78	140.94	140.75	140.788	2490900.0
2007-01-05 13:00:00	SPY	ETF	140.79	140.94	140.58	140.8195	4127400.0
2007-01-05 13:30:00	SPY	ETF	140.82	140.94	140.63	140.85	1990600.0
2007-01-05 14:00:00	SPY	ETF	140.84	140.92	140.6	140.74	3998000.0
2007-01-05 14:30:00	SPY	ETF	140.73	140.83	140.62	140.65	1921800.0
2007-01-05 15:00:00	SPY	ETF	140.65	140.88	140.46	140.83	3910700.0
2007-01-05 15:30:00	SPY	ETF	140.83	140.97	140.68	140.76	4442500.0
2007-01-05 16:00:00	SPY	ETF	140.73	140.7895	140.5	140.5	853000.0
2007-01-05 16:30:00	SPY	ETF	140.5	140.8131	140.48	140.69	325500.0
2007-01-05 17:00:00	SPY	ETF	140.69	140.69	140.5	140.58	159000.0
2007-01-05 17:30:00	SPY	ETF	140.51	140.51	140.48	140.48	4500.0
2007-01-05 18:00:00	SPY	ETF	140.53	140.58	140.46	140.46	24900.0
2007-01-05 18:30:00	SPY	ETF	140.45	140.45	140.42	140.42	18700.0
2007-01-05 19:00:00	SPY	ETF	140.44	140.55	140.42	140.42	6100.0
2007-01-05 19:30:00	SPY	ETF	140.47	140.48	140.44	140.44	1700.0
2007-01-05 04:00:00	QQQ	ETF	44.0	44.0	43.98	43.98	1200.0
2007-01-05 06:00:00	QQQ	ETF	43.96	44.01	43.96	43.96	7200.0
2007-01-05 06:30:00	QQQ	ETF	44.02	44.02	43.83	43.99	36500.0
2007-01-05 07:00:00	QQQ	ETF	43.96	43.96	43.88	43.89	77133.0
2007-01-05 07:30:00	QQQ	ETF	43.9	43.9	43.8	43.83	400787.0
2007-01-05 08:00:00	QQQ	ETF	43.84	43.86	43.8	43.86	3557980.0
2007-01-05 08:30:00	QQQ	ETF	43.87	44.06	43.85	43.96	7612908.0
2007-01-05 09:00:00	QQQ	ETF	43.96	43.98	43.94	43.94	805339.0
2007-01-05 09:30:00	QQQ	ETF	43.93	43.95	43.7	43.71	23128800.0
2007-01-05 10:00:00	QQQ	ETF	43.71	43.93	43.7	43.82	12325500.0
2007-01-05 10:30:00	QQQ	ETF	43.83	43.88	43.76	43.79	6100000.0
2007-01-05 11:00:00	QQQ	ETF	43.78	43.82	43.49	43.51	16419700.0
2007-01-05 11:30:00	QQQ	ETF	43.5	43.62	43.48	43.6	7873500.0
2007-01-05 12:00:00	QQQ	ETF	43.6	43.97	43.6	43.69	4333200.0
2007-01-05 12:30:00	QQQ	ETF	43.69	43.78	43.67	43.72	5554000.0
2007-01-05 13:00:00	QQQ	ETF	43.73	43.89	43.67	43.81	4781100.0
2007-01-05 13:30:00	QQQ	ETF	43.8	43.84	43.72	43.81	4445200.0
2007-01-05 14:00:00	QQQ	ETF	43.81	43.85	43.7	43.76	4605600.0
2007-01-05 14:30:00	QQQ	ETF	43.76	43.83	43.73	43.73	2980700.0
2007-01-05 15:00:00	QQQ	ETF	43.73	43.83	43.65	43.8	6286600.0
2007-01-05 15:30:00	QQQ	ETF	43.8	43.91	43.75	43.84	7987600.0
2007-01-05 16:00:00	QQQ	ETF	43.84	43.86	43.71	43.77	2048917.0

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

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