PREVIEW / etf_30min / 2013-05-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-08.parquet
  size:    313 KB
  rows:    10,728

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
2013-05-08 04:00:00	SPY	ETF	162.4	162.43	162.4	162.43	400.0
2013-05-08 04:30:00	SPY	ETF	162.49	162.54	162.48	162.54	1600.0
2013-05-08 05:00:00	SPY	ETF	162.51	162.54	162.49	162.54	2700.0
2013-05-08 05:30:00	SPY	ETF	162.54	162.6	162.5	162.6	20700.0
2013-05-08 06:00:00	SPY	ETF	162.6	162.63	162.58	162.58	4400.0
2013-05-08 06:30:00	SPY	ETF	162.57	162.68	162.57	162.63	23400.0
2013-05-08 07:00:00	SPY	ETF	162.63	162.65	162.57	162.62	63775.0
2013-05-08 07:30:00	SPY	ETF	162.63	162.66	162.57	162.57	296305.0
2013-05-08 08:00:00	SPY	ETF	162.57	162.63	162.35	162.41	387729.0
2013-05-08 08:30:00	SPY	ETF	162.41	162.46	162.19	162.22	455002.0
2013-05-08 09:00:00	SPY	ETF	162.24	162.42	162.22	162.41	620643.0
2013-05-08 09:30:00	SPY	ETF	162.42	162.78	162.33	162.78	11479966.0
2013-05-08 10:00:00	SPY	ETF	162.775	162.92	162.71	162.87	9658665.0
2013-05-08 10:30:00	SPY	ETF	162.875	163.08	162.82	162.95	6464240.0
2013-05-08 11:00:00	SPY	ETF	162.94	163.14	162.94	163.12	4308408.0
2013-05-08 11:30:00	SPY	ETF	163.12	163.2	163.08	163.18	4765818.0
2013-05-08 12:00:00	SPY	ETF	163.175	163.24	163.07	163.0807	4037825.0
2013-05-08 12:30:00	SPY	ETF	163.09	163.13	162.98	163.1	3617015.0
2013-05-08 13:00:00	SPY	ETF	163.11	163.23	163.1	163.15	3313577.0
2013-05-08 13:30:00	SPY	ETF	163.14	163.23	163.02	163.05	4279214.0
2013-05-08 14:00:00	SPY	ETF	163.06	163.15	163.03	163.08	5612773.0
2013-05-08 14:30:00	SPY	ETF	163.08	163.09	162.73	162.931	6637550.0
2013-05-08 15:00:00	SPY	ETF	162.94	163.31	162.91	163.2523	7790021.0
2013-05-08 15:30:00	SPY	ETF	163.26	163.39	163.22	163.34	12188452.0
2013-05-08 16:00:00	SPY	ETF	163.35	163.43	163.0009	163.35	5289341.0
2013-05-08 16:30:00	SPY	ETF	163.3643	163.4	163.312	163.36	735692.0
2013-05-08 17:00:00	SPY	ETF	163.36	163.37	163.33	163.34	636952.0
2013-05-08 17:30:00	SPY	ETF	163.36	163.36	163.34	163.34	91500.0
2013-05-08 18:00:00	SPY	ETF	163.34	163.35	163.28	163.31	309223.0
2013-05-08 18:30:00	SPY	ETF	163.31	163.33	163.27	163.27	35583.0
2013-05-08 19:00:00	SPY	ETF	163.27	163.31	163.27	163.31	18246.0
2013-05-08 19:30:00	SPY	ETF	163.3	163.31	163.28	163.31	41572.0
2013-05-08 07:00:00	QQQ	ETF	72.4	72.42	72.4	72.42	300.0
2013-05-08 07:30:00	QQQ	ETF	72.42	72.42	72.4	72.4	1095.0
2013-05-08 08:00:00	QQQ	ETF	72.4	72.4	72.32	72.33	17612.0
2013-05-08 08:30:00	QQQ	ETF	72.33	72.36	72.27	72.27	56148.0
2013-05-08 09:00:00	QQQ	ETF	72.28	72.34	72.27	72.31	51932.0
2013-05-08 09:30:00	QQQ	ETF	72.31	72.5	72.2	72.5	3286990.0
2013-05-08 10:00:00	QQQ	ETF	72.5098	72.61	72.45	72.61	1881847.0
2013-05-08 10:30:00	QQQ	ETF	72.61	72.71	72.56	72.65	1304390.0
2013-05-08 11:00:00	QQQ	ETF	72.65	72.71	72.63	72.669	1292713.0
2013-05-08 11:30:00	QQQ	ETF	72.67	72.72	72.65	72.692	658359.0
2013-05-08 12:00:00	QQQ	ETF	72.7	72.73	72.66	72.67	855386.0
2013-05-08 12:30:00	QQQ	ETF	72.68	72.7	72.62	72.67	1264511.0
2013-05-08 13:00:00	QQQ	ETF	72.685	72.74	72.66	72.71	885283.0
2013-05-08 13:30:00	QQQ	ETF	72.7001	72.74	72.64	72.67	952062.0
2013-05-08 14:00:00	QQQ	ETF	72.66	72.7001	72.64	72.66	1386144.0
2013-05-08 14:30:00	QQQ	ETF	72.66	72.66	72.46	72.57	1464860.0
2013-05-08 15:00:00	QQQ	ETF	72.57	72.76	72.55	72.72	1263238.0
2013-05-08 15:30:00	QQQ	ETF	72.73	72.77	72.69	72.7	2620855.0

> showing 50 of 10,728 rows — these rows as CSV

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