PREVIEW / etf_1hour / 2010-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-15.parquet
  size:    174 KB
  rows:    5,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
2010-12-15 04:00:00	SPY	ETF	124.28	124.29	124.06	124.28	9911.0
2010-12-15 05:00:00	SPY	ETF	124.2	124.2	124.05	124.1	5400.0
2010-12-15 06:00:00	SPY	ETF	124.08	124.29	124.07	124.22	28350.0
2010-12-15 07:00:00	SPY	ETF	124.23	124.46	124.17	124.25	256323.0
2010-12-15 08:00:00	SPY	ETF	124.27	124.49	124.13	124.34	1210129.0
2010-12-15 09:00:00	SPY	ETF	124.34	124.77	124.22	124.76	15511294.0
2010-12-15 10:00:00	SPY	ETF	124.75	124.93	124.72	124.8	15813001.0
2010-12-15 11:00:00	SPY	ETF	124.81	124.92	124.575	124.67	15180943.0
2010-12-15 12:00:00	SPY	ETF	124.67	124.69	124.21	124.33	17409944.0
2010-12-15 13:00:00	SPY	ETF	124.33	124.6675	124.22	124.5	13908772.0
2010-12-15 14:00:00	SPY	ETF	124.51	124.52	123.89	123.985	22787648.0
2010-12-15 15:00:00	SPY	ETF	123.99	124.47	123.95	124.1	35532234.0
2010-12-15 16:00:00	SPY	ETF	124.12	124.905	124.11	124.33	17297894.0
2010-12-15 17:00:00	SPY	ETF	124.35	124.36	124.21	124.32	209226.0
2010-12-15 18:00:00	SPY	ETF	124.31	124.31	124.05	124.08	261435.0
2010-12-15 19:00:00	SPY	ETF	124.09	124.12	123.95	124.12	137035.0
2010-12-15 04:00:00	QQQ	ETF	54.25	54.25	54.25	54.25	300.0
2010-12-15 05:00:00	QQQ	ETF	54.22	54.22	54.2	54.2	200.0
2010-12-15 06:00:00	QQQ	ETF	54.21	54.3	54.2	54.29	7900.0
2010-12-15 07:00:00	QQQ	ETF	54.3	54.38	54.3	54.34	19400.0
2010-12-15 08:00:00	QQQ	ETF	54.33	54.42	54.27	54.32	283690.0
2010-12-15 09:00:00	QQQ	ETF	54.32	54.44	54.3	54.43	4567458.0
2010-12-15 10:00:00	QQQ	ETF	54.43	54.7	54.3926	54.63	9835922.0
2010-12-15 11:00:00	QQQ	ETF	54.63	54.68	54.39	54.48	9111080.0
2010-12-15 12:00:00	QQQ	ETF	54.48	54.49	54.2	54.23	3954295.0
2010-12-15 13:00:00	QQQ	ETF	54.233	54.28	54.14	54.27	10183133.0
2010-12-15 14:00:00	QQQ	ETF	54.27	54.29	54.03	54.07	7383168.0
2010-12-15 15:00:00	QQQ	ETF	54.06	54.32	54.05	54.17	13242519.0
2010-12-15 16:00:00	QQQ	ETF	54.16	54.26	54.1283	54.24	2268572.0
2010-12-15 17:00:00	QQQ	ETF	54.19	54.25	54.19	54.21	4516.0
2010-12-15 18:00:00	QQQ	ETF	54.23	54.23	54.12	54.12	7200.0
2010-12-15 19:00:00	QQQ	ETF	54.12	54.12	54.08	54.11	18502.0
2010-12-15 04:00:00	IWM	ETF	77.0	77.01	77.0	77.0	739.0
2010-12-15 05:00:00	IWM	ETF	77.02	77.02	77.02	77.02	3000.0
2010-12-15 06:00:00	IWM	ETF	76.99	77.14	76.98	77.14	6500.0
2010-12-15 07:00:00	IWM	ETF	77.14	77.3	77.14	77.17	85000.0
2010-12-15 08:00:00	IWM	ETF	77.17	77.31	76.97	77.17	466435.0
2010-12-15 09:00:00	IWM	ETF	77.16	77.82	77.14	77.82	5002214.0
2010-12-15 10:00:00	IWM	ETF	77.81	78.06	77.74	77.98	6796316.0
2010-12-15 11:00:00	IWM	ETF	77.97	78.01	77.61	77.75	3783857.0
2010-12-15 12:00:00	IWM	ETF	77.75	77.85	77.31	77.37	5236490.0
2010-12-15 13:00:00	IWM	ETF	77.38	77.49	77.26	77.488	2812514.0
2010-12-15 14:00:00	IWM	ETF	77.48	77.51	76.92	76.95	4987089.0
2010-12-15 15:00:00	IWM	ETF	76.955	77.37	76.92	77.05	12471704.0
2010-12-15 16:00:00	IWM	ETF	77.04	77.19	77.03	77.19	1233983.0
2010-12-15 17:00:00	IWM	ETF	77.19	77.2	77.15	77.2	13101.0
2010-12-15 18:00:00	IWM	ETF	77.17	77.17	77.08	77.08	3900.0
2010-12-15 19:00:00	IWM	ETF	77.09	77.09	77.03	77.07	4000.0
2010-12-15 06:00:00	DIA	ETF	114.73	114.73	114.73	114.73	100.0
2010-12-15 07:00:00	DIA	ETF	114.71	114.88	114.7	114.76	2000.0

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

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