PREVIEW / etf_30min / 2010-10-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-19.parquet
  size:    278 KB
  rows:    9,193

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-10-19 04:00:00	SPY	ETF	117.88	118.0	117.88	117.94	20267.0
2010-10-19 04:30:00	SPY	ETF	117.93	117.93	117.9	117.9	800.0
2010-10-19 05:00:00	SPY	ETF	118.07	118.07	118.0	118.06	3100.0
2010-10-19 05:30:00	SPY	ETF	118.06	118.06	118.05	118.05	6920.0
2010-10-19 06:00:00	SPY	ETF	118.03	118.03	117.98	117.98	5500.0
2010-10-19 06:30:00	SPY	ETF	118.05	118.24	118.04	118.06	48700.0
2010-10-19 07:00:00	SPY	ETF	118.04	118.09	117.49	117.66	859910.0
2010-10-19 07:30:00	SPY	ETF	117.68	117.71	117.36	117.59	1170765.0
2010-10-19 08:00:00	SPY	ETF	117.62	117.8	117.4	117.53	3046121.0
2010-10-19 08:30:00	SPY	ETF	117.58	117.74	117.38	117.4	3143730.0
2010-10-19 09:00:00	SPY	ETF	117.41	117.49	117.03	117.18	3063832.0
2010-10-19 09:30:00	SPY	ETF	117.19	117.42	116.76	116.97	28381269.0
2010-10-19 10:00:00	SPY	ETF	116.97	117.6	116.87	117.51	21857271.0
2010-10-19 10:30:00	SPY	ETF	117.51	117.72	117.34	117.5	14225759.0
2010-10-19 11:00:00	SPY	ETF	117.5	117.54	117.25	117.35	10041931.0
2010-10-19 11:30:00	SPY	ETF	117.3401	117.83	117.3401	117.77	14809394.0
2010-10-19 12:00:00	SPY	ETF	117.77	117.85	117.56	117.61	6217628.0
2010-10-19 12:30:00	SPY	ETF	117.6	117.63	117.43	117.63	6269937.0
2010-10-19 13:00:00	SPY	ETF	117.63	117.63	117.265	117.27	7844861.0
2010-10-19 13:30:00	SPY	ETF	117.28	117.48	116.77	116.86	19178738.0
2010-10-19 14:00:00	SPY	ETF	116.87	116.88	116.2	116.39	38155213.0
2010-10-19 14:30:00	SPY	ETF	116.38	116.77	116.31	116.58	19408246.0
2010-10-19 15:00:00	SPY	ETF	116.58	116.68	116.105	116.11	18957226.0
2010-10-19 15:30:00	SPY	ETF	116.1125	116.75	116.02	116.7065	32751561.0
2010-10-19 16:00:00	SPY	ETF	116.75	118.5588	116.295	116.82	12865243.0
2010-10-19 16:30:00	SPY	ETF	116.82	118.28	116.6778	116.77	4348705.0
2010-10-19 17:00:00	SPY	ETF	116.76	116.82	116.75	116.76	105921.0
2010-10-19 17:30:00	SPY	ETF	116.78	116.85	116.76	116.78	91682.0
2010-10-19 18:00:00	SPY	ETF	116.77	116.79	116.72	116.75	59445.0
2010-10-19 18:30:00	SPY	ETF	116.76	116.77	116.66	116.66	79427.0
2010-10-19 19:00:00	SPY	ETF	116.65	116.67	116.6	116.65	84465.0
2010-10-19 19:30:00	SPY	ETF	116.65	116.66	116.54	116.55	54130.0
2010-10-19 04:00:00	QQQ	ETF	50.89	50.92	50.89	50.92	5250.0
2010-10-19 04:30:00	QQQ	ETF	50.91	50.92	50.91	50.92	200.0
2010-10-19 05:30:00	QQQ	ETF	50.95	50.95	50.95	50.95	100.0
2010-10-19 06:00:00	QQQ	ETF	50.97	50.97	50.97	50.97	300.0
2010-10-19 06:30:00	QQQ	ETF	50.99	51.05	50.97	50.97	5800.0
2010-10-19 07:00:00	QQQ	ETF	50.99	51.0	50.79	50.87	308153.0
2010-10-19 07:30:00	QQQ	ETF	50.86	50.89	50.78	50.86	84000.0
2010-10-19 08:00:00	QQQ	ETF	50.87	50.95	50.78	50.95	626477.0
2010-10-19 08:30:00	QQQ	ETF	50.97	51.0	50.81	50.84	1219794.0
2010-10-19 09:00:00	QQQ	ETF	50.82	50.82	50.64	50.82	1459670.0
2010-10-19 09:30:00	QQQ	ETF	50.82	50.92	50.42	50.61	14297962.0
2010-10-19 10:00:00	QQQ	ETF	50.6	51.11	50.52	51.02	13131675.0
2010-10-19 10:30:00	QQQ	ETF	51.03	51.18	50.98	51.06	6635028.0
2010-10-19 11:00:00	QQQ	ETF	51.065	51.07	50.89	50.94	5337475.0
2010-10-19 11:30:00	QQQ	ETF	50.95	51.22	50.95	51.19	4808861.0
2010-10-19 12:00:00	QQQ	ETF	51.18	51.24	51.09	51.1201	2595518.0
2010-10-19 12:30:00	QQQ	ETF	51.12	51.19	51.06	51.19	3413474.0
2010-10-19 13:00:00	QQQ	ETF	51.18	51.18	50.97	50.97	3923957.0

> showing 50 of 9,193 rows — these rows as CSV

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