PREVIEW / etf_30min / 2010-07-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-22.parquet
  size:    252 KB
  rows:    8,342

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-07-22 04:00:00	SPY	ETF	107.21	107.37	107.18	107.37	1654.0
2010-07-22 04:30:00	SPY	ETF	107.43	108.01	107.43	107.95	11082.0
2010-07-22 05:00:00	SPY	ETF	108.0	108.06	107.9	108.05	11000.0
2010-07-22 05:30:00	SPY	ETF	108.05	108.26	108.05	108.21	18100.0
2010-07-22 06:00:00	SPY	ETF	108.17	108.2	108.0	108.09	68857.0
2010-07-22 06:30:00	SPY	ETF	108.15	108.36	108.15	108.23	68026.0
2010-07-22 07:00:00	SPY	ETF	108.26	108.27	108.11	108.14	620088.0
2010-07-22 07:30:00	SPY	ETF	108.18	108.31	108.1	108.15	2391466.0
2010-07-22 08:00:00	SPY	ETF	108.26	108.27	107.58	108.06	2826995.0
2010-07-22 08:30:00	SPY	ETF	108.04	108.38	107.87	108.36	3250000.0
2010-07-22 09:00:00	SPY	ETF	108.38	108.4	108.28	108.34	2117680.0
2010-07-22 09:30:00	SPY	ETF	108.34	109.12	108.33	109.07	35357611.0
2010-07-22 10:00:00	SPY	ETF	109.07	109.67	109.06	109.47	32231299.0
2010-07-22 10:30:00	SPY	ETF	109.48	109.85	109.37	109.64	17141136.0
2010-07-22 11:00:00	SPY	ETF	109.64	109.82	109.54	109.7516	12916413.0
2010-07-22 11:30:00	SPY	ETF	109.75	109.81	109.25	109.38	18328968.0
2010-07-22 12:00:00	SPY	ETF	109.38	109.58	109.32	109.47	11124722.0
2010-07-22 12:30:00	SPY	ETF	109.475	109.58	109.375	109.56	5267519.0
2010-07-22 13:00:00	SPY	ETF	109.56	109.75	109.53	109.65	5718644.0
2010-07-22 13:30:00	SPY	ETF	109.64	109.7	109.45	109.53	6026801.0
2010-07-22 14:00:00	SPY	ETF	109.53	109.94	109.53	109.92	9428188.0
2010-07-22 14:30:00	SPY	ETF	109.92	109.94	109.58	109.78	11917296.0
2010-07-22 15:00:00	SPY	ETF	109.77	109.93	109.575	109.7405	13088267.0
2010-07-22 15:30:00	SPY	ETF	109.75	109.8	109.06	109.46	46883150.0
2010-07-22 16:00:00	SPY	ETF	109.46	109.8	108.545	109.29	13847093.0
2010-07-22 16:30:00	SPY	ETF	109.28	109.3	109.11	109.2	12730163.0
2010-07-22 17:00:00	SPY	ETF	109.18	109.33	109.17	109.3	2205316.0
2010-07-22 17:30:00	SPY	ETF	109.34	109.39	109.33	109.36	70236.0
2010-07-22 18:00:00	SPY	ETF	109.36	109.48	109.29	109.32	97315.0
2010-07-22 18:30:00	SPY	ETF	109.32	109.39	109.32	109.39	66070.0
2010-07-22 19:00:00	SPY	ETF	109.38	109.43	109.38	109.4	52990.0
2010-07-22 19:30:00	SPY	ETF	109.41	109.65	109.33	109.61	104686.0
2010-07-22 04:00:00	QQQ	ETF	44.7	44.88	44.7	44.88	586.0
2010-07-22 04:30:00	QQQ	ETF	44.95	45.01	44.95	45.01	200.0
2010-07-22 05:30:00	QQQ	ETF	45.23	45.23	45.23	45.23	100.0
2010-07-22 06:00:00	QQQ	ETF	45.14	45.15	45.09	45.09	7900.0
2010-07-22 06:30:00	QQQ	ETF	45.15	45.2	45.15	45.16	4400.0
2010-07-22 07:00:00	QQQ	ETF	45.15	45.17	45.13	45.16	25735.0
2010-07-22 07:30:00	QQQ	ETF	45.17	45.2	45.13	45.13	151061.0
2010-07-22 08:00:00	QQQ	ETF	44.95	45.17	44.95	45.1	204862.0
2010-07-22 08:30:00	QQQ	ETF	45.1	45.2	44.99	45.2	503403.0
2010-07-22 09:00:00	QQQ	ETF	45.2	45.26	45.18	45.25	743716.0
2010-07-22 09:30:00	QQQ	ETF	45.26	45.54	45.24	45.49	12918339.0
2010-07-22 10:00:00	QQQ	ETF	45.49	45.8	45.49	45.7401	11307843.0
2010-07-22 10:30:00	QQQ	ETF	45.75	45.98	45.7	45.88	5488038.0
2010-07-22 11:00:00	QQQ	ETF	45.89	45.94	45.82	45.92	3563883.0
2010-07-22 11:30:00	QQQ	ETF	45.92	45.94	45.65	45.71	4030918.0
2010-07-22 12:00:00	QQQ	ETF	45.71	45.79	45.65	45.76	3004779.0
2010-07-22 12:30:00	QQQ	ETF	45.76	45.77	45.68	45.7599	2077487.0
2010-07-22 13:00:00	QQQ	ETF	45.76	45.86	45.75	45.79	1692942.0

> showing 50 of 8,342 rows — these rows as CSV

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