PREVIEW / etf_30min / 2010-07-20

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-20.parquet
  size:    258 KB
  rows:    8,407

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-20 04:00:00	SPY	ETF	106.6	106.69	106.52	106.69	5400.0
2010-07-20 04:30:00	SPY	ETF	106.67	106.67	106.66	106.66	1800.0
2010-07-20 05:00:00	SPY	ETF	106.7	106.7	106.51	106.51	1600.0
2010-07-20 05:30:00	SPY	ETF	106.58	106.58	106.05	106.05	1900.0
2010-07-20 06:00:00	SPY	ETF	106.08	106.08	105.85	105.88	15700.0
2010-07-20 06:30:00	SPY	ETF	105.85	106.08	105.83	106.08	31526.0
2010-07-20 07:00:00	SPY	ETF	106.08	106.2	106.03	106.12	255623.0
2010-07-20 07:30:00	SPY	ETF	106.15	106.2	105.86	106.1	632060.0
2010-07-20 08:00:00	SPY	ETF	106.1	106.16	105.63	105.72	2678218.0
2010-07-20 08:30:00	SPY	ETF	105.7	106.11	105.62	106.02	4040185.0
2010-07-20 09:00:00	SPY	ETF	106.01	106.1	105.86	105.87	1148744.0
2010-07-20 09:30:00	SPY	ETF	105.87	106.48	105.82	106.35	29400452.0
2010-07-20 10:00:00	SPY	ETF	106.36	106.61	106.03	106.49	20678820.0
2010-07-20 10:30:00	SPY	ETF	106.49	106.7	106.36	106.52	14210800.0
2010-07-20 11:00:00	SPY	ETF	106.52	107.05	106.45	106.9601	18977971.0
2010-07-20 11:30:00	SPY	ETF	106.9601	107.02	106.63	106.6699	8576655.0
2010-07-20 12:00:00	SPY	ETF	106.66	106.85	106.51	106.6	6164078.0
2010-07-20 12:30:00	SPY	ETF	106.6	106.92	106.58	106.89	4955189.0
2010-07-20 13:00:00	SPY	ETF	106.88	107.09	106.82	107.0699	7187008.0
2010-07-20 13:30:00	SPY	ETF	107.06	108.0	107.01	107.97	22951656.0
2010-07-20 14:00:00	SPY	ETF	107.96	108.0	107.55	107.72	17665243.0
2010-07-20 14:30:00	SPY	ETF	107.73	107.97	107.66	107.75	13251199.0
2010-07-20 15:00:00	SPY	ETF	107.76	108.36	107.65	108.24	19554928.0
2010-07-20 15:30:00	SPY	ETF	108.24	108.56	107.8	108.47	39665024.0
2010-07-20 16:00:00	SPY	ETF	108.47	108.79	106.185	108.64	15862113.0
2010-07-20 16:30:00	SPY	ETF	108.64	109.05	107.2712	108.7	5404328.0
2010-07-20 17:00:00	SPY	ETF	108.7	108.74	107.2712	108.62	4551529.0
2010-07-20 17:30:00	SPY	ETF	108.67	108.68	108.62	108.65	83134.0
2010-07-20 18:00:00	SPY	ETF	108.64	108.66	108.48	108.56	218907.0
2010-07-20 18:30:00	SPY	ETF	108.54	108.58	108.52	108.53	110709.0
2010-07-20 19:00:00	SPY	ETF	108.53	108.61	108.53	108.56	12707.0
2010-07-20 19:30:00	SPY	ETF	108.61	108.7	108.61	108.63	15428.0
2010-07-20 04:30:00	QQQ	ETF	44.3	44.33	44.3	44.33	3400.0
2010-07-20 05:30:00	QQQ	ETF	44.25	44.26	44.11	44.11	1360.0
2010-07-20 06:00:00	QQQ	ETF	44.1	44.1	43.95	43.95	2300.0
2010-07-20 06:30:00	QQQ	ETF	44.0	44.06	44.0	44.06	300.0
2010-07-20 07:00:00	QQQ	ETF	44.07	44.11	44.04	44.11	29516.0
2010-07-20 07:30:00	QQQ	ETF	44.09	44.11	44.0	44.1	51014.0
2010-07-20 08:00:00	QQQ	ETF	44.1	44.4	43.9	43.96	557900.0
2010-07-20 08:30:00	QQQ	ETF	43.95	44.1	43.88	44.08	1232106.0
2010-07-20 09:00:00	QQQ	ETF	44.07	44.13	43.98	44.0	822711.0
2010-07-20 09:30:00	QQQ	ETF	43.99	44.12	43.86	44.08	10457560.0
2010-07-20 10:00:00	QQQ	ETF	44.08	44.19	43.9	44.12	6815659.0
2010-07-20 10:30:00	QQQ	ETF	44.115	44.31	44.07	44.23	8504357.0
2010-07-20 11:00:00	QQQ	ETF	44.23	44.49	44.22	44.45	3976429.0
2010-07-20 11:30:00	QQQ	ETF	44.45	44.48	44.2123	44.34	2230979.0
2010-07-20 12:00:00	QQQ	ETF	44.3429	44.45	44.29	44.32	3105758.0
2010-07-20 12:30:00	QQQ	ETF	44.315	44.48	44.315	44.47	2670076.0
2010-07-20 13:00:00	QQQ	ETF	44.48	44.57	44.44	44.57	1870598.0
2010-07-20 13:30:00	QQQ	ETF	44.56	44.93	44.45	44.91	9858336.0

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

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