PREVIEW / etf_30min / 2013-05-31

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-31.parquet
  size:    336 KB
  rows:    11,207

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-31 04:00:00	SPY	ETF	165.18	165.18	164.86	164.86	23716.0
2013-05-31 04:30:00	SPY	ETF	164.93	164.97	164.85	164.85	28400.0
2013-05-31 05:00:00	SPY	ETF	164.81	164.84	164.71	164.77	78255.0
2013-05-31 05:30:00	SPY	ETF	164.77	164.77	164.57	164.77	74550.0
2013-05-31 06:00:00	SPY	ETF	164.72	164.96	164.66	164.94	113359.0
2013-05-31 06:30:00	SPY	ETF	164.93	165.12	164.91	165.01	201415.0
2013-05-31 07:00:00	SPY	ETF	165.02	165.14	164.98	165.06	165374.0
2013-05-31 07:30:00	SPY	ETF	165.09	165.27	164.97	165.12	218430.0
2013-05-31 08:00:00	SPY	ETF	165.12	165.25	164.91	165.05	862333.0
2013-05-31 08:30:00	SPY	ETF	165.05	165.89	164.7025	165.09	849838.0
2013-05-31 09:00:00	SPY	ETF	165.07	165.4	165.03	165.38	1022689.0
2013-05-31 09:30:00	SPY	ETF	165.37	165.93	165.12	165.62	18993476.0
2013-05-31 10:00:00	SPY	ETF	165.62	165.81	165.19	165.39	12149299.0
2013-05-31 10:30:00	SPY	ETF	165.4	165.8247	165.34	165.51	8467821.0
2013-05-31 11:00:00	SPY	ETF	165.51	166.31	165.48	165.98	11299688.0
2013-05-31 11:30:00	SPY	ETF	165.98	166.12	165.83	165.86	5394615.0
2013-05-31 12:00:00	SPY	ETF	165.86	165.9	165.45	165.68	7086394.0
2013-05-31 12:30:00	SPY	ETF	165.675	165.75	165.54	165.59	3858754.0
2013-05-31 13:00:00	SPY	ETF	165.58	165.85	165.58	165.741	2861606.0
2013-05-31 13:30:00	SPY	ETF	165.741	165.75	165.42	165.55	3936560.0
2013-05-31 14:00:00	SPY	ETF	165.555	165.57	165.18	165.232	6723110.0
2013-05-31 14:30:00	SPY	ETF	165.24	165.245	164.65	164.67	10486067.0
2013-05-31 15:00:00	SPY	ETF	164.67	165.11	164.58	164.731	11632089.0
2013-05-31 15:30:00	SPY	ETF	164.73	164.77	163.13	163.44	39930102.0
2013-05-31 16:00:00	SPY	ETF	163.43	165.997	163.22	163.4	19107551.0
2013-05-31 16:30:00	SPY	ETF	163.4	163.52	163.28	163.29	4985667.0
2013-05-31 17:00:00	SPY	ETF	163.3	163.36	163.04	163.05	678611.0
2013-05-31 17:30:00	SPY	ETF	163.05	163.12	162.9	162.93	299539.0
2013-05-31 18:00:00	SPY	ETF	162.93	163.11	162.86	163.11	221287.0
2013-05-31 18:30:00	SPY	ETF	163.1	163.23	163.05	163.17	173583.0
2013-05-31 19:00:00	SPY	ETF	163.16	163.2	163.16	163.2	41080.0
2013-05-31 19:30:00	SPY	ETF	163.19	163.27	163.19	163.21	34322.0
2013-05-31 04:00:00	QQQ	ETF	73.65	73.65	73.45	73.45	3100.0
2013-05-31 04:30:00	QQQ	ETF	73.48	73.48	73.43	73.43	1300.0
2013-05-31 05:00:00	QQQ	ETF	73.38	73.38	73.37	73.38	1484.0
2013-05-31 05:30:00	QQQ	ETF	73.32	73.36	73.32	73.36	1500.0
2013-05-31 06:00:00	QQQ	ETF	73.39	73.42	73.38	73.42	4900.0
2013-05-31 06:30:00	QQQ	ETF	73.46	73.52	73.43	73.48	4400.0
2013-05-31 07:00:00	QQQ	ETF	73.48	73.52	73.45	73.51	10825.0
2013-05-31 07:30:00	QQQ	ETF	73.51	73.63	73.51	73.58	13928.0
2013-05-31 08:00:00	QQQ	ETF	73.59	73.6	73.5	73.52	48065.0
2013-05-31 08:30:00	QQQ	ETF	73.52	73.93	73.52	73.56	71992.0
2013-05-31 09:00:00	QQQ	ETF	73.56	73.67	73.54	73.64	61611.0
2013-05-31 09:30:00	QQQ	ETF	73.65	73.99	73.56	73.89	4900691.0
2013-05-31 10:00:00	QQQ	ETF	73.9	73.98	73.78	73.85	2608323.0
2013-05-31 10:30:00	QQQ	ETF	73.86	73.98	73.84	73.9	1974675.0
2013-05-31 11:00:00	QQQ	ETF	73.9	74.21	73.89	74.12	3470786.0
2013-05-31 11:30:00	QQQ	ETF	74.12	74.185	74.06	74.07	1894423.0
2013-05-31 12:00:00	QQQ	ETF	74.07	74.08	73.89	74.0	1670317.0
2013-05-31 12:30:00	QQQ	ETF	74.01	74.035	73.95	74.0	895520.0

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

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