PREVIEW / etf_30min / 2012-05-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-09.parquet
  size:    295 KB
  rows:    9,980

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-05-09 04:00:00	SPY	ETF	136.1	136.1	135.68	135.68	2700.0
2012-05-09 04:30:00	SPY	ETF	135.74	135.83	135.41	135.41	23500.0
2012-05-09 05:00:00	SPY	ETF	135.44	135.66	135.44	135.66	29700.0
2012-05-09 05:30:00	SPY	ETF	135.6	135.62	135.44	135.56	15725.0
2012-05-09 06:00:00	SPY	ETF	135.61	135.65	135.52	135.55	3500.0
2012-05-09 06:30:00	SPY	ETF	135.64	135.64	135.16	135.29	86592.0
2012-05-09 07:00:00	SPY	ETF	135.3	135.35	135.06	135.27	454639.0
2012-05-09 07:30:00	SPY	ETF	135.3	135.49	135.22	135.46	326142.0
2012-05-09 08:00:00	SPY	ETF	135.46	135.9	135.06	135.2	895332.0
2012-05-09 08:30:00	SPY	ETF	135.2	135.63	134.96	135.04	1136165.0
2012-05-09 09:00:00	SPY	ETF	135.03	135.94	134.88	135.11	1709545.0
2012-05-09 09:30:00	SPY	ETF	135.1	135.43	134.93	135.19	21929877.0
2012-05-09 10:00:00	SPY	ETF	135.19	135.52	134.49	134.54	31592948.0
2012-05-09 10:30:00	SPY	ETF	134.54	135.36	134.53	135.2	18850919.0
2012-05-09 11:00:00	SPY	ETF	135.2	136.02	135.03	135.8399	18745701.0
2012-05-09 11:30:00	SPY	ETF	135.84	136.21	135.7	135.89	12512052.0
2012-05-09 12:00:00	SPY	ETF	135.89	135.93	135.69	135.77	7034308.0
2012-05-09 12:30:00	SPY	ETF	135.77	135.85	135.42	135.8	11523662.0
2012-05-09 13:00:00	SPY	ETF	135.8	136.33	135.77	136.13	13414719.0
2012-05-09 13:30:00	SPY	ETF	136.14	136.61	136.1	136.32	11387190.0
2012-05-09 14:00:00	SPY	ETF	136.32	136.38	135.97	136.29	11135278.0
2012-05-09 14:30:00	SPY	ETF	136.29	136.31	135.88	135.9	7815432.0
2012-05-09 15:00:00	SPY	ETF	135.89	136.03	135.65	135.79	14201900.0
2012-05-09 15:30:00	SPY	ETF	135.8	136.19	135.63	135.73	21767035.0
2012-05-09 16:00:00	SPY	ETF	135.73	135.9722	135.49	135.65	10150468.0
2012-05-09 16:30:00	SPY	ETF	135.67	135.73	135.32	135.36	599911.0
2012-05-09 17:00:00	SPY	ETF	135.665	135.665	135.12	135.26	2680108.0
2012-05-09 17:30:00	SPY	ETF	135.28	135.34	135.25	135.3	25804.0
2012-05-09 18:00:00	SPY	ETF	135.3	135.39	135.29	135.36	87234.0
2012-05-09 18:30:00	SPY	ETF	135.37	135.42	135.36	135.42	58691.0
2012-05-09 19:00:00	SPY	ETF	135.41	135.5	135.4	135.46	55010.0
2012-05-09 19:30:00	SPY	ETF	135.47	135.5	135.44	135.48	51871.0
2012-05-09 05:00:00	QQQ	ETF	64.06	64.07	64.06	64.07	1600.0
2012-05-09 05:30:00	QQQ	ETF	64.05	64.05	64.05	64.05	100.0
2012-05-09 06:00:00	QQQ	ETF	64.06	64.06	64.06	64.06	500.0
2012-05-09 06:30:00	QQQ	ETF	64.03	64.03	63.87	63.89	3800.0
2012-05-09 07:00:00	QQQ	ETF	63.92	63.92	63.8	63.92	66850.0
2012-05-09 07:30:00	QQQ	ETF	63.92	64.0	63.87	64.0	24030.0
2012-05-09 08:00:00	QQQ	ETF	64.0	64.02	63.8	63.92	79154.0
2012-05-09 08:30:00	QQQ	ETF	63.91	63.99	63.77	63.85	305110.0
2012-05-09 09:00:00	QQQ	ETF	63.83	63.9	63.75	63.78	597412.0
2012-05-09 09:30:00	QQQ	ETF	63.78	64.15	63.72	64.095	6109191.0
2012-05-09 10:00:00	QQQ	ETF	64.09	64.19	63.51	63.54	10110982.0
2012-05-09 10:30:00	QQQ	ETF	63.54	64.07	63.54	64.001	6101915.0
2012-05-09 11:00:00	QQQ	ETF	64.0	64.4	63.91	64.3	9471967.0
2012-05-09 11:30:00	QQQ	ETF	64.31	64.585	64.23	64.43	5303440.0
2012-05-09 12:00:00	QQQ	ETF	64.43	64.4423	64.28	64.35	2501806.0
2012-05-09 12:30:00	QQQ	ETF	64.349	64.349	64.13	64.32	2969893.0
2012-05-09 13:00:00	QQQ	ETF	64.31	64.48	64.15	64.3246	4835266.0
2012-05-09 13:30:00	QQQ	ETF	64.33	64.68	64.3	64.509	5730204.0

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

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