PREVIEW / etf_30min / 2011-02-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-08.parquet
  size:    276 KB
  rows:    9,316

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
2011-02-08 04:00:00	SPY	ETF	132.13	132.13	132.13	132.13	300.0
2011-02-08 04:30:00	SPY	ETF	132.15	132.17	132.15	132.17	600.0
2011-02-08 05:00:00	SPY	ETF	132.3	132.35	132.3	132.35	500.0
2011-02-08 05:30:00	SPY	ETF	132.35	132.4	131.97	131.97	20840.0
2011-02-08 06:00:00	SPY	ETF	132.0	132.0	132.0	132.0	100.0
2011-02-08 06:30:00	SPY	ETF	132.1	132.12	132.04	132.04	7500.0
2011-02-08 07:00:00	SPY	ETF	132.04	132.04	131.81	131.86	306477.0
2011-02-08 07:30:00	SPY	ETF	131.88	132.04	131.83	131.98	349064.0
2011-02-08 08:00:00	SPY	ETF	132.29	132.29	131.83	131.97	2433032.0
2011-02-08 08:30:00	SPY	ETF	131.97	132.13	131.93	131.94	635904.0
2011-02-08 09:00:00	SPY	ETF	131.94	132.1	131.93	132.09	592449.0
2011-02-08 09:30:00	SPY	ETF	132.09	132.13	131.73	132.06	14164208.0
2011-02-08 10:00:00	SPY	ETF	132.06	132.35	132.05	132.24	10774728.0
2011-02-08 10:30:00	SPY	ETF	132.24	132.26	132.1	132.155	6938252.0
2011-02-08 11:00:00	SPY	ETF	132.16	132.22	131.98	132.1749	7733319.0
2011-02-08 11:30:00	SPY	ETF	132.172	132.36	132.16	132.3	6161055.0
2011-02-08 12:00:00	SPY	ETF	132.31	132.3762	132.23	132.36	4176060.0
2011-02-08 12:30:00	SPY	ETF	132.35	132.46	132.29	132.3262	3898594.0
2011-02-08 13:00:00	SPY	ETF	132.33	132.33	132.17	132.18	3673955.0
2011-02-08 13:30:00	SPY	ETF	132.18	132.45	132.13	132.21	3503240.0
2011-02-08 14:00:00	SPY	ETF	132.205	132.39	132.205	132.38	3018360.0
2011-02-08 14:30:00	SPY	ETF	132.385	132.49	132.27	132.33	5762660.0
2011-02-08 15:00:00	SPY	ETF	132.33	132.54	132.3	132.4199	6514740.0
2011-02-08 15:30:00	SPY	ETF	132.42	132.64	132.41	132.59	11822975.0
2011-02-08 16:00:00	SPY	ETF	132.58	132.62	131.9	132.56	4268620.0
2011-02-08 16:30:00	SPY	ETF	132.56	132.6475	132.52	132.56	643892.0
2011-02-08 17:00:00	SPY	ETF	132.56	132.59	132.53	132.57	115160.0
2011-02-08 17:30:00	SPY	ETF	132.55	132.63	132.55	132.59	100583.0
2011-02-08 18:00:00	SPY	ETF	132.58	132.6	132.57	132.58	114680.0
2011-02-08 18:30:00	SPY	ETF	132.58	132.58	132.57	132.57	37630.0
2011-02-08 19:00:00	SPY	ETF	132.58	132.59	132.56	132.56	40649.0
2011-02-08 19:30:00	SPY	ETF	132.56	132.59	132.49	132.53	31803.0
2011-02-08 06:30:00	QQQ	ETF	57.67	57.67	57.67	57.67	600.0
2011-02-08 07:00:00	QQQ	ETF	57.61	57.62	57.51	57.52	617704.0
2011-02-08 07:30:00	QQQ	ETF	57.53	57.59	57.51	57.58	606243.0
2011-02-08 08:00:00	QQQ	ETF	57.52	57.6	57.51	57.6	1590636.0
2011-02-08 08:30:00	QQQ	ETF	57.6	57.66	57.57	57.57	267755.0
2011-02-08 09:00:00	QQQ	ETF	57.57	57.66	57.57	57.65	284862.0
2011-02-08 09:30:00	QQQ	ETF	57.64	57.8	57.56	57.79	6724938.0
2011-02-08 10:00:00	QQQ	ETF	57.79	57.9	57.765	57.83	4499907.0
2011-02-08 10:30:00	QQQ	ETF	57.84	57.84	57.76	57.77	2424158.0
2011-02-08 11:00:00	QQQ	ETF	57.765	57.78	57.65	57.745	2183768.0
2011-02-08 11:30:00	QQQ	ETF	57.74	57.85	57.73	57.85	1626357.0
2011-02-08 12:00:00	QQQ	ETF	57.85	57.9	57.83	57.87	1387795.0
2011-02-08 12:30:00	QQQ	ETF	57.8604	57.91	57.85	57.8675	1256885.0
2011-02-08 13:00:00	QQQ	ETF	57.86	57.88	57.8	57.8179	1064535.0
2011-02-08 13:30:00	QQQ	ETF	57.819	57.85	57.78	57.811	1037045.0
2011-02-08 14:00:00	QQQ	ETF	57.82	57.91	57.82	57.91	904458.0
2011-02-08 14:30:00	QQQ	ETF	57.9	57.97	57.88	57.91	2722385.0
2011-02-08 15:00:00	QQQ	ETF	57.9	58.01	57.89	57.935	2006242.0

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

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