PREVIEW / etf_30min / 2013-06-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-03.parquet
  size:    333 KB
  rows:    11,198

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-06-03 04:00:00	SPY	ETF	163.67	163.67	163.27	163.46	50900.0
2013-06-03 04:30:00	SPY	ETF	163.48	163.54	163.39	163.49	17400.0
2013-06-03 05:00:00	SPY	ETF	163.48	163.77	163.45	163.77	28400.0
2013-06-03 05:30:00	SPY	ETF	163.72	163.9	163.66	163.84	105050.0
2013-06-03 06:00:00	SPY	ETF	163.84	163.88	163.75	163.88	2600.0
2013-06-03 06:30:00	SPY	ETF	163.88	164.17	163.87	164.17	158643.0
2013-06-03 07:00:00	SPY	ETF	164.175	164.38	164.11	164.27	452642.0
2013-06-03 07:30:00	SPY	ETF	164.27	164.38	164.09	164.15	649257.0
2013-06-03 08:00:00	SPY	ETF	164.14	164.37	163.31	163.91	904564.0
2013-06-03 08:30:00	SPY	ETF	163.93	163.99	163.77	163.93	749996.0
2013-06-03 09:00:00	SPY	ETF	163.92	163.99	163.81	163.83	1078915.0
2013-06-03 09:30:00	SPY	ETF	163.83	163.88	163.22	163.27	22794214.0
2013-06-03 10:00:00	SPY	ETF	163.42	164.17	163.07	163.68	23587440.0
2013-06-03 10:30:00	SPY	ETF	163.69	163.72	162.88	163.36	16286630.0
2013-06-03 11:00:00	SPY	ETF	163.35	163.42	162.66	162.78	13215721.0
2013-06-03 11:30:00	SPY	ETF	162.77	163.19	162.6599	163.118	9174690.0
2013-06-03 12:00:00	SPY	ETF	163.12	163.34	162.86	163.14	6860938.0
2013-06-03 12:30:00	SPY	ETF	163.14	163.37	162.9	163.23	5534718.0
2013-06-03 13:00:00	SPY	ETF	163.23	163.49	163.12	163.22	5432231.0
2013-06-03 13:30:00	SPY	ETF	163.21	163.47	163.07	163.3613	4670975.0
2013-06-03 14:00:00	SPY	ETF	163.3699	163.74	163.27	163.4925	7168718.0
2013-06-03 14:30:00	SPY	ETF	163.495	163.93	163.37	163.71	6583320.0
2013-06-03 15:00:00	SPY	ETF	163.71	163.95	163.61	163.9001	7360809.0
2013-06-03 15:30:00	SPY	ETF	163.91	164.46	163.77	164.38	18327801.0
2013-06-03 16:00:00	SPY	ETF	164.34	164.4456	163.4787	164.19	8840099.0
2013-06-03 16:30:00	SPY	ETF	164.19	164.38	163.4787	164.21	1561837.0
2013-06-03 17:00:00	SPY	ETF	164.18	164.2	163.5133	164.15	126107.0
2013-06-03 17:30:00	SPY	ETF	164.13	164.15	164.13	164.14	15047.0
2013-06-03 18:00:00	SPY	ETF	164.13	164.19	164.12	164.16	58909.0
2013-06-03 18:30:00	SPY	ETF	164.13	164.13	163.71	163.82	188454.0
2013-06-03 19:00:00	SPY	ETF	163.82	163.95	163.82	163.95	105376.0
2013-06-03 19:30:00	SPY	ETF	163.94	164.06	163.94	164.0	75218.0
2013-06-03 04:00:00	QQQ	ETF	73.17	73.17	73.0	73.11	16830.0
2013-06-03 04:30:00	QQQ	ETF	73.08	73.11	73.05	73.11	1595.0
2013-06-03 05:00:00	QQQ	ETF	73.08	73.23	73.08	73.23	6570.0
2013-06-03 05:30:00	QQQ	ETF	73.2	73.3	73.17	73.26	2900.0
2013-06-03 06:00:00	QQQ	ETF	73.29	73.3	73.23	73.3	9000.0
2013-06-03 06:30:00	QQQ	ETF	73.3	73.41	73.3	73.41	7159.0
2013-06-03 07:00:00	QQQ	ETF	73.42	73.49	73.41	73.46	327925.0
2013-06-03 07:30:00	QQQ	ETF	73.5	73.5	73.42	73.44	173444.0
2013-06-03 08:00:00	QQQ	ETF	73.43	73.46	73.36	73.36	108736.0
2013-06-03 08:30:00	QQQ	ETF	73.355	73.36	73.27	73.34	85892.0
2013-06-03 09:00:00	QQQ	ETF	73.325	73.35	73.27	73.28	249655.0
2013-06-03 09:30:00	QQQ	ETF	73.29	73.32	72.9	73.11	6018518.0
2013-06-03 10:00:00	QQQ	ETF	73.07	73.31	72.9	73.08	5425139.0
2013-06-03 10:30:00	QQQ	ETF	73.085	73.09	72.77	72.86	3917555.0
2013-06-03 11:00:00	QQQ	ETF	72.86	72.9	72.54	72.57	3767413.0
2013-06-03 11:30:00	QQQ	ETF	72.56	72.67	72.43	72.63	2271736.0
2013-06-03 12:00:00	QQQ	ETF	72.62	72.7	72.475	72.63	1520200.0
2013-06-03 12:30:00	QQQ	ETF	72.6363	72.76	72.52	72.75	1355369.0

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

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