PREVIEW / etf_30min / 2014-11-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-13.parquet
  size:    363 KB
  rows:    12,124

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
2014-11-13 04:00:00	SPY	ETF	204.48	204.62	204.41	204.61	4898.0
2014-11-13 04:30:00	SPY	ETF	204.66	204.69	204.59	204.59	2420.0
2014-11-13 05:00:00	SPY	ETF	204.52	204.64	204.49	204.64	8465.0
2014-11-13 05:30:00	SPY	ETF	204.66	204.82	204.66	204.73	11634.0
2014-11-13 06:00:00	SPY	ETF	204.76	204.87	204.71	204.71	10701.0
2014-11-13 06:30:00	SPY	ETF	204.7	204.75	204.66	204.75	45438.0
2014-11-13 07:00:00	SPY	ETF	204.78	204.78	204.58	204.59	111187.0
2014-11-13 07:30:00	SPY	ETF	204.59	204.64	204.43	204.54	228094.0
2014-11-13 08:00:00	SPY	ETF	204.52	204.71	204.13	204.16	306374.0
2014-11-13 08:30:00	SPY	ETF	204.21	204.34	204.06	204.19	528459.0
2014-11-13 09:00:00	SPY	ETF	204.19	204.33	204.15	204.16	397261.0
2014-11-13 09:30:00	SPY	ETF	204.16	204.68	204.13	204.58	8393220.0
2014-11-13 10:00:00	SPY	ETF	204.58	204.77	204.36	204.71	6225729.0
2014-11-13 10:30:00	SPY	ETF	204.71	204.83	204.65	204.65	4632045.0
2014-11-13 11:00:00	SPY	ETF	204.655	204.7	204.06	204.24	7795257.0
2014-11-13 11:30:00	SPY	ETF	204.25	204.25	203.74	204.0699	6323951.0
2014-11-13 12:00:00	SPY	ETF	204.07	204.22	203.84	204.175	3749934.0
2014-11-13 12:30:00	SPY	ETF	204.175	204.28	203.96	203.965	2842527.0
2014-11-13 13:00:00	SPY	ETF	203.9699	204.03	203.39	203.55	6228233.0
2014-11-13 13:30:00	SPY	ETF	203.55	203.73	203.21	203.585	4675115.0
2014-11-13 14:00:00	SPY	ETF	203.585	203.71	203.26	203.48	4111893.0
2014-11-13 14:30:00	SPY	ETF	203.48	203.87	203.46	203.685	4915548.0
2014-11-13 15:00:00	SPY	ETF	203.685	204.02	203.64	203.679	4575565.0
2014-11-13 15:30:00	SPY	ETF	203.67	204.33	203.63	204.17	11852061.0
2014-11-13 16:00:00	SPY	ETF	204.18	204.21	203.87	203.93	3200949.0
2014-11-13 16:30:00	SPY	ETF	203.93	203.97	203.85	203.9	712410.0
2014-11-13 17:00:00	SPY	ETF	203.9	203.92	203.86	203.88	61955.0
2014-11-13 17:30:00	SPY	ETF	203.88	203.9	203.81	203.82	115055.0
2014-11-13 18:00:00	SPY	ETF	203.81	203.89	203.74	203.87	118643.0
2014-11-13 18:30:00	SPY	ETF	203.88	204.05	203.88	204.04	65036.0
2014-11-13 19:00:00	SPY	ETF	204.02	204.06	203.98	204.04	46366.0
2014-11-13 19:30:00	SPY	ETF	204.02	204.05	203.97	204.05	36040.0
2014-11-13 04:00:00	QQQ	ETF	102.68	102.88	102.68	102.88	2000.0
2014-11-13 05:00:00	QQQ	ETF	102.94	102.94	102.94	102.94	100.0
2014-11-13 06:00:00	QQQ	ETF	102.88	102.95	102.88	102.95	1600.0
2014-11-13 06:30:00	QQQ	ETF	102.87	102.88	102.85	102.88	1900.0
2014-11-13 07:00:00	QQQ	ETF	102.84	102.84	102.8	102.81	20911.0
2014-11-13 07:30:00	QQQ	ETF	102.79	102.85	102.74	102.81	47911.0
2014-11-13 08:00:00	QQQ	ETF	102.79	102.81	102.63	102.63	62559.0
2014-11-13 08:30:00	QQQ	ETF	102.63	102.71	102.6	102.64	61848.0
2014-11-13 09:00:00	QQQ	ETF	102.64	102.7	102.46	102.65	91886.0
2014-11-13 09:30:00	QQQ	ETF	102.65	103.12	102.62	103.1001	3438423.0
2014-11-13 10:00:00	QQQ	ETF	103.11	103.25	103.0161	103.18	1742561.0
2014-11-13 10:30:00	QQQ	ETF	103.18	103.28	103.15	103.15	1804156.0
2014-11-13 11:00:00	QQQ	ETF	103.16	103.17	102.66	102.92	2540407.0
2014-11-13 11:30:00	QQQ	ETF	102.92	102.9263	102.63	102.82	1205805.0
2014-11-13 12:00:00	QQQ	ETF	102.82	103.03	102.71	103.0098	728956.0
2014-11-13 12:30:00	QQQ	ETF	103.01	103.11	102.99	103.0	857041.0
2014-11-13 13:00:00	QQQ	ETF	103.0	103.04	102.54	102.6799	1755426.0
2014-11-13 13:30:00	QQQ	ETF	102.67	102.85	102.42	102.73	1571682.0

> showing 50 of 12,124 rows — these rows as CSV

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