PREVIEW / etf_30min / 2014-08-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-18.parquet
  size:    336 KB
  rows:    11,503

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-08-18 04:00:00	SPY	ETF	196.25	196.8	196.25	196.76	4058.0
2014-08-18 04:30:00	SPY	ETF	196.73	196.73	196.63	196.66	33301.0
2014-08-18 05:00:00	SPY	ETF	196.68	196.7	196.63	196.63	19419.0
2014-08-18 05:30:00	SPY	ETF	196.68	196.7	196.55	196.59	67520.0
2014-08-18 06:00:00	SPY	ETF	196.57	196.72	196.57	196.72	38319.0
2014-08-18 06:30:00	SPY	ETF	196.73	196.81	196.7	196.74	231884.0
2014-08-18 07:00:00	SPY	ETF	196.74	196.96	196.67	196.9	168567.0
2014-08-18 07:30:00	SPY	ETF	196.88	196.97	196.84	196.95	234461.0
2014-08-18 08:00:00	SPY	ETF	196.94	196.98	196.71	196.81	289374.0
2014-08-18 08:30:00	SPY	ETF	196.8	196.93	196.77	196.92	224431.0
2014-08-18 09:00:00	SPY	ETF	196.93	196.99	196.77	196.79	651414.0
2014-08-18 09:30:00	SPY	ETF	196.8	197.12	196.69	197.105	8724990.0
2014-08-18 10:00:00	SPY	ETF	197.11	197.24	197.02	197.11	5894692.0
2014-08-18 10:30:00	SPY	ETF	197.12	197.4	197.06	197.341	4396263.0
2014-08-18 11:00:00	SPY	ETF	197.35	197.36	197.2	197.3201	4381024.0
2014-08-18 11:30:00	SPY	ETF	197.33	197.39	197.22	197.32	2703026.0
2014-08-18 12:00:00	SPY	ETF	197.315	197.45	197.31	197.39	2705320.0
2014-08-18 12:30:00	SPY	ETF	197.39	197.45	197.28	197.28	2579528.0
2014-08-18 13:00:00	SPY	ETF	197.28	197.33	197.21	197.295	2037808.0
2014-08-18 13:30:00	SPY	ETF	197.3	197.37	197.26	197.295	2080533.0
2014-08-18 14:00:00	SPY	ETF	197.29	197.31	197.18	197.25	3520915.0
2014-08-18 14:30:00	SPY	ETF	197.25	197.27	197.14	197.21	2834319.0
2014-08-18 15:00:00	SPY	ETF	197.22	197.29	197.15	197.17	4874707.0
2014-08-18 15:30:00	SPY	ETF	197.165	197.38	197.13	197.36	11719947.0
2014-08-18 16:00:00	SPY	ETF	197.37	197.39	195.7401	197.34	8290531.0
2014-08-18 16:30:00	SPY	ETF	197.35	197.44	197.32	197.44	1135385.0
2014-08-18 17:00:00	SPY	ETF	197.43	197.44	197.38	197.44	39512.0
2014-08-18 17:30:00	SPY	ETF	197.44	197.45	197.41	197.42	86003.0
2014-08-18 18:00:00	SPY	ETF	197.42	197.47	197.42	197.44	69100.0
2014-08-18 18:30:00	SPY	ETF	197.47	197.47	197.41	197.42	20826.0
2014-08-18 19:00:00	SPY	ETF	197.45	197.52	197.45	197.52	88165.0
2014-08-18 19:30:00	SPY	ETF	197.5	197.51	197.45	197.47	30857.0
2014-08-18 04:00:00	QQQ	ETF	97.7	97.9	97.7	97.9	3899.0
2014-08-18 04:30:00	QQQ	ETF	97.87	97.89	97.85	97.85	5800.0
2014-08-18 05:00:00	QQQ	ETF	97.81	97.81	97.81	97.81	2000.0
2014-08-18 05:30:00	QQQ	ETF	97.77	97.77	97.77	97.77	600.0
2014-08-18 06:00:00	QQQ	ETF	97.82	97.85	97.82	97.85	1400.0
2014-08-18 06:30:00	QQQ	ETF	97.84	97.87	97.84	97.87	13900.0
2014-08-18 07:00:00	QQQ	ETF	97.85	97.95	97.84	97.94	64420.0
2014-08-18 07:30:00	QQQ	ETF	97.94	97.94	97.92	97.94	40100.0
2014-08-18 08:00:00	QQQ	ETF	97.95	97.95	97.86	97.86	72410.0
2014-08-18 08:30:00	QQQ	ETF	97.87	97.91	97.86	97.91	34108.0
2014-08-18 09:00:00	QQQ	ETF	97.9	97.94	97.86	97.87	232045.0
2014-08-18 09:30:00	QQQ	ETF	97.88	98.05	97.77	98.03	3919238.0
2014-08-18 10:00:00	QQQ	ETF	98.02	98.1	97.98	98.04	1557299.0
2014-08-18 10:30:00	QQQ	ETF	98.05	98.195	97.99	98.19	2834302.0
2014-08-18 11:00:00	QQQ	ETF	98.195	98.21	98.11	98.18	2534970.0
2014-08-18 11:30:00	QQQ	ETF	98.18	98.21	97.77	98.145	3330428.0
2014-08-18 12:00:00	QQQ	ETF	98.14	98.24	98.13	98.18	1070355.0
2014-08-18 12:30:00	QQQ	ETF	98.19	98.22	98.09	98.09	3550817.0

> showing 50 of 11,503 rows — these rows as CSV

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