PREVIEW / etf_1hour / 2007-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-12.parquet
  size:    61 KB
  rows:    1,942

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-12 04:00:00	SPY	ETF	142.34	142.34	142.3	142.3	3100.0
2007-01-12 06:00:00	SPY	ETF	142.15	142.23	142.15	142.23	20000.0
2007-01-12 07:00:00	SPY	ETF	142.16	142.16	142.03	142.09	363100.0
2007-01-12 08:00:00	SPY	ETF	142.05	142.36	141.94	142.1	2723700.0
2007-01-12 09:00:00	SPY	ETF	142.09	142.67	142.05	142.61	8230700.0
2007-01-12 10:00:00	SPY	ETF	142.61	142.63	142.16	142.41	11135100.0
2007-01-12 11:00:00	SPY	ETF	142.41	142.8	142.25	142.71	7610200.0
2007-01-12 12:00:00	SPY	ETF	142.72	143.03	142.61	142.97	5649400.0
2007-01-12 13:00:00	SPY	ETF	142.99	142.99	142.81	142.92	3529300.0
2007-01-12 14:00:00	SPY	ETF	142.92	142.93	142.74	142.82	3369200.0
2007-01-12 15:00:00	SPY	ETF	142.82	143.03	142.81	142.97	9555400.0
2007-01-12 16:00:00	SPY	ETF	142.97	143.35	142.907	143.29	2446800.0
2007-01-12 17:00:00	SPY	ETF	143.27	143.32	143.0	143.18	96900.0
2007-01-12 18:00:00	SPY	ETF	143.2	143.27	143.2	143.21	5800.0
2007-01-12 19:00:00	SPY	ETF	143.2	143.27	143.18	143.27	5700.0
2007-01-12 05:00:00	QQQ	ETF	45.12	45.12	45.12	45.12	1000.0
2007-01-12 06:00:00	QQQ	ETF	45.09	45.09	45.07	45.07	125000.0
2007-01-12 07:00:00	QQQ	ETF	45.11	45.11	44.9	45.03	1069607.0
2007-01-12 08:00:00	QQQ	ETF	45.0	45.15	45.0	45.05	2165821.0
2007-01-12 09:00:00	QQQ	ETF	45.05	45.32	44.98	45.28	22384480.0
2007-01-12 10:00:00	QQQ	ETF	45.29	45.29	44.97	45.13	26345800.0
2007-01-12 11:00:00	QQQ	ETF	45.12	45.29	45.07	45.23	15705400.0
2007-01-12 12:00:00	QQQ	ETF	45.23	45.35	45.18	45.32	7564200.0
2007-01-12 13:00:00	QQQ	ETF	45.32	45.33	45.22	45.27	6525400.0
2007-01-12 14:00:00	QQQ	ETF	45.26	45.28	45.18	45.22	6764200.0
2007-01-12 15:00:00	QQQ	ETF	45.21	45.33	45.21	45.32	11340900.0
2007-01-12 16:00:00	QQQ	ETF	45.32	45.45	45.31	45.41	3293916.0
2007-01-12 17:00:00	QQQ	ETF	45.4	45.43	45.4	45.41	66200.0
2007-01-12 18:00:00	QQQ	ETF	45.41	45.43	45.4	45.4	19650.0
2007-01-12 19:00:00	QQQ	ETF	45.42	45.45	45.41	45.42	14571.0
2007-01-12 08:00:00	IWM	ETF	78.21	78.3	78.09	78.19	622300.0
2007-01-12 09:00:00	IWM	ETF	78.2	78.61	78.16	78.56	4527100.0
2007-01-12 10:00:00	IWM	ETF	78.56	78.57	78.13	78.34	5975400.0
2007-01-12 11:00:00	IWM	ETF	78.34	78.57	78.2	78.48	3493900.0
2007-01-12 12:00:00	IWM	ETF	78.48	78.72	78.425	78.68	2951700.0
2007-01-12 13:00:00	IWM	ETF	78.67	78.68	78.48	78.59	2397400.0
2007-01-12 14:00:00	IWM	ETF	78.59	78.6	78.43	78.52	1796400.0
2007-01-12 15:00:00	IWM	ETF	78.53	78.82	78.53	78.82	3662800.0
2007-01-12 16:00:00	IWM	ETF	78.84	79.05	78.2229	79.0	1887200.0
2007-01-12 17:00:00	IWM	ETF	79.01	79.03	79.0	79.0	2200.0
2007-01-12 18:00:00	IWM	ETF	78.97	78.97	78.97	78.97	200.0
2007-01-12 07:00:00	DIA	ETF	124.92	124.92	124.92	124.92	600.0
2007-01-12 08:00:00	DIA	ETF	124.86	125.05	124.83	124.86	24500.0
2007-01-12 09:00:00	DIA	ETF	124.96	125.2	124.87	125.13	982200.0
2007-01-12 10:00:00	DIA	ETF	125.13	125.15	124.81	125.04	1375300.0
2007-01-12 11:00:00	DIA	ETF	125.04	125.39	124.9	125.29	593200.0
2007-01-12 12:00:00	DIA	ETF	125.29	125.5	125.27	125.46	653300.0
2007-01-12 13:00:00	DIA	ETF	125.4501	125.49	125.33	125.43	442100.0
2007-01-12 14:00:00	DIA	ETF	125.41	125.43	125.3	125.34	451000.0
2007-01-12 15:00:00	DIA	ETF	125.34	125.5	125.34	125.48	1741900.0

> showing 50 of 1,942 rows — these rows as CSV

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