PREVIEW / etf_30min / 2013-05-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-17.parquet
  size:    319 KB
  rows:    10,689

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-17 04:00:00	SPY	ETF	165.7	165.7	165.56	165.56	3150.0
2013-05-17 04:30:00	SPY	ETF	165.43	165.54	165.43	165.49	11900.0
2013-05-17 05:00:00	SPY	ETF	165.58	165.73	165.58	165.73	3125.0
2013-05-17 05:30:00	SPY	ETF	165.73	165.88	165.7	165.76	83535.0
2013-05-17 06:00:00	SPY	ETF	165.78	165.9	165.67	165.69	25900.0
2013-05-17 06:30:00	SPY	ETF	165.69	165.86	165.67	165.76	58200.0
2013-05-17 07:00:00	SPY	ETF	165.755	165.8	165.71	165.75	106238.0
2013-05-17 07:30:00	SPY	ETF	165.75	165.81	165.67	165.78	190180.0
2013-05-17 08:00:00	SPY	ETF	165.78	166.02	165.73	165.86	196150.0
2013-05-17 08:30:00	SPY	ETF	165.85	166.03	165.3257	165.97	3407618.0
2013-05-17 09:00:00	SPY	ETF	165.97	165.99	165.82	165.93	1015447.0
2013-05-17 09:30:00	SPY	ETF	165.95	166.21	165.73	166.18	14950978.0
2013-05-17 10:00:00	SPY	ETF	166.19	166.36	166.11	166.255	10971832.0
2013-05-17 10:30:00	SPY	ETF	166.2499	166.36	166.01	166.02	8253500.0
2013-05-17 11:00:00	SPY	ETF	166.021	166.15	165.83	166.11	7274547.0
2013-05-17 11:30:00	SPY	ETF	166.1	166.24	166.04	166.12	4272923.0
2013-05-17 12:00:00	SPY	ETF	166.11	166.15	166.01	166.11	3340719.0
2013-05-17 12:30:00	SPY	ETF	166.111	166.18	165.97	166.05	2910503.0
2013-05-17 13:00:00	SPY	ETF	166.055	166.19	166.04	166.16	2516430.0
2013-05-17 13:30:00	SPY	ETF	166.16	166.2	166.09	166.14	2532677.0
2013-05-17 14:00:00	SPY	ETF	166.14	166.44	166.12	166.39	6328264.0
2013-05-17 14:30:00	SPY	ETF	166.39	166.76	166.37	166.74	11579839.0
2013-05-17 15:00:00	SPY	ETF	166.75	166.95	166.66	166.9	13803291.0
2013-05-17 15:30:00	SPY	ETF	166.9	167.04	166.84	166.97	18796237.0
2013-05-17 16:00:00	SPY	ETF	166.97	167.05	165.3258	166.98	13140243.0
2013-05-17 16:30:00	SPY	ETF	166.97	167.0223	166.84	166.9	2722428.0
2013-05-17 17:00:00	SPY	ETF	166.9	167.01	166.9	167.0	122994.0
2013-05-17 17:30:00	SPY	ETF	166.99	167.02	166.97	167.02	114192.0
2013-05-17 18:00:00	SPY	ETF	167.0	167.03	166.95	166.95	19673.0
2013-05-17 18:30:00	SPY	ETF	167.02	167.04	166.98	167.0	4061.0
2013-05-17 19:00:00	SPY	ETF	167.01	167.02	166.98	167.02	7552.0
2013-05-17 19:30:00	SPY	ETF	166.99	167.01	166.84	166.88	51499.0
2013-05-17 04:00:00	QQQ	ETF	73.69	73.69	73.61	73.61	3100.0
2013-05-17 04:30:00	QQQ	ETF	73.6	73.6	73.6	73.6	100.0
2013-05-17 05:00:00	QQQ	ETF	73.69	73.69	73.69	73.69	100.0
2013-05-17 05:30:00	QQQ	ETF	73.7	73.7	73.7	73.7	150.0
2013-05-17 06:00:00	QQQ	ETF	73.68	73.72	73.66	73.69	10900.0
2013-05-17 06:30:00	QQQ	ETF	73.73	73.73	73.73	73.73	100.0
2013-05-17 07:00:00	QQQ	ETF	73.74	73.77	73.72	73.74	25500.0
2013-05-17 07:30:00	QQQ	ETF	73.78	73.78	73.78	73.78	25600.0
2013-05-17 08:00:00	QQQ	ETF	73.79	73.84	73.79	73.8	28744.0
2013-05-17 08:30:00	QQQ	ETF	73.8	73.89	73.79	73.85	136981.0
2013-05-17 09:00:00	QQQ	ETF	73.84	73.97	73.6	73.94	76476.0
2013-05-17 09:30:00	QQQ	ETF	73.95	74.12	73.7301	73.94	3728938.0
2013-05-17 10:00:00	QQQ	ETF	73.95	74.05	73.9	73.95	2158482.0
2013-05-17 10:30:00	QQQ	ETF	73.96	74.02	73.88	73.93	1117023.0
2013-05-17 11:00:00	QQQ	ETF	73.92	73.96	73.76	73.88	2978042.0
2013-05-17 11:30:00	QQQ	ETF	73.885	73.95	73.87	73.908	1871949.0
2013-05-17 12:00:00	QQQ	ETF	73.91	73.93	73.85	73.88	779203.0
2013-05-17 12:30:00	QQQ	ETF	73.88	73.8999	73.79	73.89	544015.0

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

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