PREVIEW / etf_30min / 2012-07-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-05.parquet
  size:    286 KB
  rows:    9,620

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
2012-07-05 04:00:00	SPY	ETF	137.37	137.37	137.25	137.31	2000.0
2012-07-05 04:30:00	SPY	ETF	137.39	137.42	137.35	137.35	800.0
2012-07-05 05:00:00	SPY	ETF	137.36	137.41	137.33	137.41	6300.0
2012-07-05 05:30:00	SPY	ETF	137.46	137.46	137.36	137.36	1400.0
2012-07-05 06:00:00	SPY	ETF	137.4	137.4	137.33	137.36	28100.0
2012-07-05 06:30:00	SPY	ETF	137.35	137.85	137.28	137.85	48700.0
2012-07-05 07:00:00	SPY	ETF	137.76	138.06	137.48	137.68	387706.0
2012-07-05 07:30:00	SPY	ETF	137.71	138.0	137.12	137.22	2250969.0
2012-07-05 08:00:00	SPY	ETF	137.25	138.25	137.17	137.59	3650349.0
2012-07-05 08:30:00	SPY	ETF	137.56	137.64	136.76	137.02	2141922.0
2012-07-05 09:00:00	SPY	ETF	137.03	137.23	136.8	136.91	2645150.0
2012-07-05 09:30:00	SPY	ETF	136.9	137.08	136.55	136.62	18859556.0
2012-07-05 10:00:00	SPY	ETF	136.61	137.8	136.29	136.575	12343950.0
2012-07-05 10:30:00	SPY	ETF	136.5982	136.97	136.53	136.89	7865953.0
2012-07-05 11:00:00	SPY	ETF	136.89	137.16	136.885	137.11	7579169.0
2012-07-05 11:30:00	SPY	ETF	137.1	137.16	136.88	136.97	8193426.0
2012-07-05 12:00:00	SPY	ETF	136.9701	137.13	136.92	136.93	4347608.0
2012-07-05 12:30:00	SPY	ETF	136.93	137.0	136.81	136.99	3871389.0
2012-07-05 13:00:00	SPY	ETF	136.99	137.15	136.97	137.09	3339818.0
2012-07-05 13:30:00	SPY	ETF	137.095	137.35	137.01	137.32	5790056.0
2012-07-05 14:00:00	SPY	ETF	137.33	137.4	137.23	137.33	3460060.0
2012-07-05 14:30:00	SPY	ETF	137.33	137.34	137.07	137.08	5885310.0
2012-07-05 15:00:00	SPY	ETF	137.08	137.17	136.89	137.03	8899972.0
2012-07-05 15:30:00	SPY	ETF	137.03	137.1	136.73	136.805	15792632.0
2012-07-05 16:00:00	SPY	ETF	136.81	137.4144	136.58	136.75	7006711.0
2012-07-05 16:30:00	SPY	ETF	136.75	136.9	136.75	136.85	694058.0
2012-07-05 17:00:00	SPY	ETF	136.83	136.84	136.81	136.82	7498.0
2012-07-05 17:30:00	SPY	ETF	136.81	136.85	136.81	136.81	4300.0
2012-07-05 18:00:00	SPY	ETF	136.8	136.81	136.71	136.71	37110.0
2012-07-05 18:30:00	SPY	ETF	136.74	136.82	136.71	136.81	25600.0
2012-07-05 19:00:00	SPY	ETF	136.82	136.83	136.81	136.83	4300.0
2012-07-05 19:30:00	SPY	ETF	136.78	136.87	136.76	136.87	86205.0
2012-07-05 05:30:00	QQQ	ETF	64.9	64.9	64.9	64.9	500.0
2012-07-05 06:30:00	QQQ	ETF	65.0	65.03	65.0	65.03	3200.0
2012-07-05 07:00:00	QQQ	ETF	65.16	65.21	64.96	65.01	713668.0
2012-07-05 07:30:00	QQQ	ETF	65.01	65.04	64.73	64.77	642605.0
2012-07-05 08:00:00	QQQ	ETF	64.78	65.44	64.6	64.92	2687455.0
2012-07-05 08:30:00	QQQ	ETF	64.89	64.94	64.66	64.77	255218.0
2012-07-05 09:00:00	QQQ	ETF	64.77	64.89	64.72	64.78	999475.0
2012-07-05 09:30:00	QQQ	ETF	64.78	64.92	64.62	64.66	4582662.0
2012-07-05 10:00:00	QQQ	ETF	64.66	64.71	64.48	64.68	2920585.0
2012-07-05 10:30:00	QQQ	ETF	64.67	65.0	64.67	64.97	3226684.0
2012-07-05 11:00:00	QQQ	ETF	64.97	65.13	64.97	65.08	2856344.0
2012-07-05 11:30:00	QQQ	ETF	65.08	65.11	64.94	65.0	3040360.0
2012-07-05 12:00:00	QQQ	ETF	65.01	65.09	65.0	65.0199	1067031.0
2012-07-05 12:30:00	QQQ	ETF	65.02	65.04	64.96	65.039	1897437.0
2012-07-05 13:00:00	QQQ	ETF	65.04	65.14	65.0101	65.11	742241.0
2012-07-05 13:30:00	QQQ	ETF	65.12	65.22	65.07	65.21	1493396.0
2012-07-05 14:00:00	QQQ	ETF	65.2018	65.25	65.16	65.18	1471271.0
2012-07-05 14:30:00	QQQ	ETF	65.19	65.19	65.04	65.05	1212987.0

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

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