PREVIEW / etf_1hour / 2010-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-31.parquet
  size:    168 KB
  rows:    5,219

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-31 04:00:00	SPY	ETF	125.88	125.88	125.8	125.8	500.0
2010-12-31 06:00:00	SPY	ETF	125.74	125.75	125.7	125.7	11000.0
2010-12-31 07:00:00	SPY	ETF	125.67	125.67	125.54	125.54	52863.0
2010-12-31 08:00:00	SPY	ETF	125.54	125.57	125.38	125.5	646456.0
2010-12-31 09:00:00	SPY	ETF	125.51	125.63	125.33	125.44	9709411.0
2010-12-31 10:00:00	SPY	ETF	125.43	125.72	125.36	125.7	9512568.0
2010-12-31 11:00:00	SPY	ETF	125.71	125.78	125.65	125.75	4891838.0
2010-12-31 12:00:00	SPY	ETF	125.75	125.87	125.64	125.72	8073688.0
2010-12-31 13:00:00	SPY	ETF	125.73	125.85	125.71	125.77	6679727.0
2010-12-31 14:00:00	SPY	ETF	125.77	125.87	125.73	125.8	5810138.0
2010-12-31 15:00:00	SPY	ETF	125.8099	125.86	125.52	125.8	29737056.0
2010-12-31 16:00:00	SPY	ETF	125.81	126.13	125.396	126.0	14272542.0
2010-12-31 17:00:00	SPY	ETF	126.0	126.0571	125.99	126.0	293176.0
2010-12-31 18:00:00	SPY	ETF	126.03	126.04	125.98	126.0	49916.0
2010-12-31 19:00:00	SPY	ETF	126.0	126.05	125.99	126.03	13494.0
2010-12-31 04:00:00	QQQ	ETF	54.65	54.65	54.65	54.65	200.0
2010-12-31 05:00:00	QQQ	ETF	54.62	54.62	54.62	54.62	200.0
2010-12-31 06:00:00	QQQ	ETF	54.62	54.62	54.62	54.62	350.0
2010-12-31 07:00:00	QQQ	ETF	54.59	54.6	54.59	54.59	520.0
2010-12-31 08:00:00	QQQ	ETF	54.58	54.62	54.55	54.59	24897.0
2010-12-31 09:00:00	QQQ	ETF	54.59	54.62	54.21	54.33	11870510.0
2010-12-31 10:00:00	QQQ	ETF	54.33	54.36	54.24	54.3465	3701756.0
2010-12-31 11:00:00	QQQ	ETF	54.345	54.38	54.32	54.3302	3087379.0
2010-12-31 12:00:00	QQQ	ETF	54.33	54.37	54.27	54.315	2622176.0
2010-12-31 13:00:00	QQQ	ETF	54.32	54.41	54.3	54.36	2334013.0
2010-12-31 14:00:00	QQQ	ETF	54.36	54.41	54.35	54.39	1776672.0
2010-12-31 15:00:00	QQQ	ETF	54.4	54.46	54.311	54.46	5723158.0
2010-12-31 16:00:00	QQQ	ETF	54.46	54.6306	54.43	54.44	3990566.0
2010-12-31 17:00:00	QQQ	ETF	54.44	54.55	54.44	54.51	22600.0
2010-12-31 18:00:00	QQQ	ETF	54.51	54.51	54.5	54.5	23900.0
2010-12-31 19:00:00	QQQ	ETF	54.52	54.55	54.52	54.54	3300.0
2010-12-31 07:00:00	IWM	ETF	78.66	78.66	78.59	78.59	3600.0
2010-12-31 08:00:00	IWM	ETF	78.6	78.82	78.49	78.59	890277.0
2010-12-31 09:00:00	IWM	ETF	78.59	78.87	78.58	78.69	3428281.0
2010-12-31 10:00:00	IWM	ETF	78.69	78.75	78.57	78.71	3489594.0
2010-12-31 11:00:00	IWM	ETF	78.71	78.77	78.64	78.727	1768297.0
2010-12-31 12:00:00	IWM	ETF	78.73	78.88	78.71	78.7599	2930825.0
2010-12-31 13:00:00	IWM	ETF	78.75	78.84	78.72	78.74	2260264.0
2010-12-31 14:00:00	IWM	ETF	78.748	78.75	78.67	78.705	1653259.0
2010-12-31 15:00:00	IWM	ETF	78.7	78.72	78.17	78.22	12555028.0
2010-12-31 16:00:00	IWM	ETF	78.22	78.7	78.16	78.45	3899541.0
2010-12-31 17:00:00	IWM	ETF	78.53	78.53	78.48	78.52	4050.0
2010-12-31 07:00:00	DIA	ETF	115.42	115.42	115.38	115.39	1600.0
2010-12-31 08:00:00	DIA	ETF	115.31	115.32	115.25	115.25	1100.0
2010-12-31 09:00:00	DIA	ETF	115.32	115.38	115.09	115.119	387791.0
2010-12-31 10:00:00	DIA	ETF	115.13	115.44	115.04	115.4101	541142.0
2010-12-31 11:00:00	DIA	ETF	115.42	115.5	115.37	115.47	116186.0
2010-12-31 12:00:00	DIA	ETF	115.4601	115.73	115.4593	115.551	452276.0
2010-12-31 13:00:00	DIA	ETF	115.55	115.62	115.5	115.541	250219.0
2010-12-31 14:00:00	DIA	ETF	115.54	115.57	115.47	115.5201	241485.0

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

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