PREVIEW / etf_30min / 2012-01-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-17.parquet
  size:    287 KB
  rows:    9,871

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-01-17 04:00:00	SPY	ETF	130.1	130.51	130.1	130.51	10294.0
2012-01-17 04:30:00	SPY	ETF	130.5	130.61	130.47	130.61	1356.0
2012-01-17 05:00:00	SPY	ETF	130.63	130.65	130.61	130.61	9810.0
2012-01-17 05:30:00	SPY	ETF	130.6	130.6	130.41	130.51	7275.0
2012-01-17 06:00:00	SPY	ETF	130.4	130.49	130.38	130.4	56311.0
2012-01-17 06:30:00	SPY	ETF	130.41	130.44	130.29	130.34	170421.0
2012-01-17 07:00:00	SPY	ETF	130.34	130.56	130.28	130.53	364193.0
2012-01-17 07:30:00	SPY	ETF	130.5	130.53	130.34	130.34	278380.0
2012-01-17 08:00:00	SPY	ETF	130.34	130.56	130.34	130.48	1025579.0
2012-01-17 08:30:00	SPY	ETF	130.51	130.53	130.1	130.13	1638432.0
2012-01-17 09:00:00	SPY	ETF	130.14	130.26	130.01	130.08	1416437.0
2012-01-17 09:30:00	SPY	ETF	130.08	130.32	129.98	130.0501	18475625.0
2012-01-17 10:00:00	SPY	ETF	130.05	130.065	129.75	129.95	11962610.0
2012-01-17 10:30:00	SPY	ETF	129.94	130.01	129.71	129.855	10870511.0
2012-01-17 11:00:00	SPY	ETF	129.85	130.07	129.83	130.02	7402703.0
2012-01-17 11:30:00	SPY	ETF	130.03	130.08	129.95	130.0	4303575.0
2012-01-17 12:00:00	SPY	ETF	130.0	130.13	129.93	130.01	6359164.0
2012-01-17 12:30:00	SPY	ETF	130.01	130.02	129.71	129.84	5222624.0
2012-01-17 13:00:00	SPY	ETF	129.83	129.93	129.83	129.86	3022374.0
2012-01-17 13:30:00	SPY	ETF	129.865	129.93	129.73	129.86	3999810.0
2012-01-17 14:00:00	SPY	ETF	129.85	129.9	129.75	129.76	3706602.0
2012-01-17 14:30:00	SPY	ETF	129.76	129.78	129.3	129.39	9895714.0
2012-01-17 15:00:00	SPY	ETF	129.39	129.43	129.06	129.2715	10208313.0
2012-01-17 15:30:00	SPY	ETF	129.28	129.43	129.19	129.33	18727276.0
2012-01-17 16:00:00	SPY	ETF	129.32	129.42	129.28	129.36	9891798.0
2012-01-17 16:30:00	SPY	ETF	129.36	129.7548	129.33	129.46	1490012.0
2012-01-17 17:00:00	SPY	ETF	129.5	129.56	129.42	129.49	117334.0
2012-01-17 17:30:00	SPY	ETF	129.49	129.5	129.43	129.44	37950.0
2012-01-17 18:00:00	SPY	ETF	129.46	129.52	129.31	129.49	70115.0
2012-01-17 18:30:00	SPY	ETF	129.5	129.57	129.46	129.57	101259.0
2012-01-17 19:00:00	SPY	ETF	129.56	129.59	129.49	129.49	80158.0
2012-01-17 19:30:00	SPY	ETF	129.5	129.54	129.46	129.47	30478.0
2012-01-17 04:00:00	QQQ	ETF	58.52	58.83	58.52	58.83	1850.0
2012-01-17 04:30:00	QQQ	ETF	58.89	58.96	58.89	58.96	1533.0
2012-01-17 05:30:00	QQQ	ETF	58.87	58.87	58.85	58.85	1100.0
2012-01-17 06:00:00	QQQ	ETF	58.83	58.85	58.83	58.84	3088.0
2012-01-17 06:30:00	QQQ	ETF	58.82	58.82	58.77	58.77	5758.0
2012-01-17 07:00:00	QQQ	ETF	58.76	58.91	58.76	58.88	64990.0
2012-01-17 07:30:00	QQQ	ETF	58.89	58.9	58.85	58.85	12150.0
2012-01-17 08:00:00	QQQ	ETF	58.82	58.89	58.69	58.85	109410.0
2012-01-17 08:30:00	QQQ	ETF	58.83	58.83	58.7	58.71	120609.0
2012-01-17 09:00:00	QQQ	ETF	58.72	58.77	58.65	58.7	162340.0
2012-01-17 09:30:00	QQQ	ETF	58.71	58.84	58.67	58.78	3934921.0
2012-01-17 10:00:00	QQQ	ETF	58.7867	58.85	58.7	58.83	2866489.0
2012-01-17 10:30:00	QQQ	ETF	58.83	58.89	58.7802	58.85	2649020.0
2012-01-17 11:00:00	QQQ	ETF	58.86	58.96	58.84	58.93	2361139.0
2012-01-17 11:30:00	QQQ	ETF	58.93	58.95	58.88	58.8901	930861.0
2012-01-17 12:00:00	QQQ	ETF	58.8901	58.96	58.88	58.895	1447177.0
2012-01-17 12:30:00	QQQ	ETF	58.8907	58.9	58.78	58.835	1887588.0
2012-01-17 13:00:00	QQQ	ETF	58.8301	58.89	58.82	58.83	1481837.0

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

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