PREVIEW / etf_30min / 2012-05-01

all etf 30-min files

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

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-01 04:00:00	SPY	ETF	140.0	140.0	139.96	139.96	500.0
2012-05-01 04:30:00	SPY	ETF	139.95	139.95	139.93	139.93	300.0
2012-05-01 05:00:00	SPY	ETF	139.9	139.9	139.87	139.87	5400.0
2012-05-01 05:30:00	SPY	ETF	139.76	139.76	139.76	139.76	20000.0
2012-05-01 06:00:00	SPY	ETF	139.75	139.75	139.7	139.74	10100.0
2012-05-01 06:30:00	SPY	ETF	139.76	139.95	139.76	139.92	109300.0
2012-05-01 07:00:00	SPY	ETF	139.94	140.02	139.91	139.99	61394.0
2012-05-01 07:30:00	SPY	ETF	140.02	140.1	139.99	139.99	129470.0
2012-05-01 08:00:00	SPY	ETF	140.0	140.15	139.86	139.87	761151.0
2012-05-01 08:30:00	SPY	ETF	139.86	139.98	139.77	139.91	230899.0
2012-05-01 09:00:00	SPY	ETF	139.9	139.92	139.76	139.78	1222217.0
2012-05-01 09:30:00	SPY	ETF	139.79	140.08	139.63	139.7	12080309.0
2012-05-01 10:00:00	SPY	ETF	139.7	141.15	139.7	141.12	23895913.0
2012-05-01 10:30:00	SPY	ETF	141.12	141.27	141.05	141.19	8209538.0
2012-05-01 11:00:00	SPY	ETF	141.19	141.34	141.16	141.31	4619356.0
2012-05-01 11:30:00	SPY	ETF	141.3	141.66	141.28	141.53	8974158.0
2012-05-01 12:00:00	SPY	ETF	141.53	141.56	141.46	141.49	3789653.0
2012-05-01 12:30:00	SPY	ETF	141.49	141.53	141.45	141.47	3416054.0
2012-05-01 13:00:00	SPY	ETF	141.47	141.48	141.32	141.37	5920566.0
2012-05-01 13:30:00	SPY	ETF	141.38	141.4	141.235	141.33	4806656.0
2012-05-01 14:00:00	SPY	ETF	141.34	141.39	141.12	141.29	6866322.0
2012-05-01 14:30:00	SPY	ETF	141.28	141.35	141.15	141.191	7987955.0
2012-05-01 15:00:00	SPY	ETF	141.2	141.28	140.95	141.04	6998908.0
2012-05-01 15:30:00	SPY	ETF	141.04	141.05	140.61	140.72	17356650.0
2012-05-01 16:00:00	SPY	ETF	140.72	141.48	139.8917	140.57	15290193.0
2012-05-01 16:30:00	SPY	ETF	140.56	140.65	140.54	140.63	779801.0
2012-05-01 17:00:00	SPY	ETF	140.61	140.74	140.51	140.55	163574.0
2012-05-01 17:30:00	SPY	ETF	140.57	140.63	140.55	140.59	60569.0
2012-05-01 18:00:00	SPY	ETF	140.6	140.67	140.6	140.62	21951.0
2012-05-01 18:30:00	SPY	ETF	140.64	140.66	140.56	140.61	21180.0
2012-05-01 19:00:00	SPY	ETF	140.61	140.61	140.57	140.61	26265.0
2012-05-01 19:30:00	SPY	ETF	140.6	140.68	140.6	140.67	20965.0
2012-05-01 06:30:00	QQQ	ETF	66.76	66.76	66.76	66.76	2000.0
2012-05-01 07:00:00	QQQ	ETF	66.79	66.84	66.77	66.84	1325.0
2012-05-01 07:30:00	QQQ	ETF	66.87	66.93	66.86	66.88	3700.0
2012-05-01 08:00:00	QQQ	ETF	66.76	66.9	66.76	66.8	873947.0
2012-05-01 08:30:00	QQQ	ETF	66.81	66.86	66.81	66.82	66704.0
2012-05-01 09:00:00	QQQ	ETF	66.8	66.8	66.68	66.69	740857.0
2012-05-01 09:30:00	QQQ	ETF	66.68	67.03	66.59	66.8	5022821.0
2012-05-01 10:00:00	QQQ	ETF	66.79	67.47	66.79	67.41	6926671.0
2012-05-01 10:30:00	QQQ	ETF	67.41	67.5	67.38	67.39	2540048.0
2012-05-01 11:00:00	QQQ	ETF	67.39	67.4895	67.38	67.46	1115920.0
2012-05-01 11:30:00	QQQ	ETF	67.46	67.63	67.42	67.54	1931156.0
2012-05-01 12:00:00	QQQ	ETF	67.53	67.5504	67.431	67.44	945627.0
2012-05-01 12:30:00	QQQ	ETF	67.44	67.4798	67.41	67.44	922602.0
2012-05-01 13:00:00	QQQ	ETF	67.45	67.45	67.31	67.33	988965.0
2012-05-01 13:30:00	QQQ	ETF	67.34	67.35	67.18	67.23	1537383.0
2012-05-01 14:00:00	QQQ	ETF	67.23	67.27	67.09	67.23	2250616.0
2012-05-01 14:30:00	QQQ	ETF	67.22	67.32	67.11	67.18	1831616.0
2012-05-01 15:00:00	QQQ	ETF	67.18	67.25	67.04	67.09	1456423.0

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

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