PREVIEW / etf_30min / 2013-05-14

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-14.parquet
  size:    322 KB
  rows:    10,787

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-14 04:00:00	SPY	ETF	163.32	163.38	163.28	163.28	7270.0
2013-05-14 05:00:00	SPY	ETF	163.29	163.29	163.21	163.27	4100.0
2013-05-14 05:30:00	SPY	ETF	163.35	163.35	163.27	163.32	800.0
2013-05-14 06:00:00	SPY	ETF	163.3	163.31	163.25	163.28	30100.0
2013-05-14 06:30:00	SPY	ETF	163.26	163.26	163.14	163.22	29792.0
2013-05-14 07:00:00	SPY	ETF	163.22	163.42	163.22	163.32	68100.0
2013-05-14 07:30:00	SPY	ETF	163.37	163.73	163.34	163.7	696313.0
2013-05-14 08:00:00	SPY	ETF	163.7	163.92	163.2	163.75	832189.0
2013-05-14 08:30:00	SPY	ETF	163.71	163.78	163.54	163.65	1136243.0
2013-05-14 09:00:00	SPY	ETF	163.66	163.77	163.57	163.66	1487647.0
2013-05-14 09:30:00	SPY	ETF	163.67	164.3	163.67	164.25	15761921.0
2013-05-14 10:00:00	SPY	ETF	164.25	164.71	164.25	164.6762	10841319.0
2013-05-14 10:30:00	SPY	ETF	164.67	164.99	164.64	164.965	9493489.0
2013-05-14 11:00:00	SPY	ETF	164.969	165.0	164.81	164.88	5603467.0
2013-05-14 11:30:00	SPY	ETF	164.885	165.11	164.85	165.03	6013859.0
2013-05-14 12:00:00	SPY	ETF	165.03	165.21	164.95	165.02	4992286.0
2013-05-14 12:30:00	SPY	ETF	165.02	165.09	164.93	164.94	2756464.0
2013-05-14 13:00:00	SPY	ETF	164.94	165.06	164.94	165.04	2349200.0
2013-05-14 13:30:00	SPY	ETF	165.04	165.14	164.81	164.86	4706174.0
2013-05-14 14:00:00	SPY	ETF	164.86	164.98	164.75	164.88	5675729.0
2013-05-14 14:30:00	SPY	ETF	164.885	165.065	164.75	164.76	5091108.0
2013-05-14 15:00:00	SPY	ETF	164.77	165.05	164.73	164.97	5619119.0
2013-05-14 15:30:00	SPY	ETF	164.97	165.35	164.94	165.27	13571264.0
2013-05-14 16:00:00	SPY	ETF	165.26	165.33	164.3889	165.28	15251185.0
2013-05-14 16:30:00	SPY	ETF	165.28	165.28	163.5976	165.27	3917705.0
2013-05-14 17:00:00	SPY	ETF	165.28	165.3	165.24	165.28	101182.0
2013-05-14 17:30:00	SPY	ETF	165.28	165.3	165.23	165.24	169465.0
2013-05-14 18:00:00	SPY	ETF	165.25	165.25	165.17	165.2	106044.0
2013-05-14 18:30:00	SPY	ETF	165.18	165.18	165.14	165.16	67950.0
2013-05-14 19:00:00	SPY	ETF	165.19	165.19	165.16	165.19	14822.0
2013-05-14 19:30:00	SPY	ETF	165.19	165.24	165.16	165.16	27793.0
2013-05-14 04:00:00	QQQ	ETF	73.11	73.11	73.05	73.05	1500.0
2013-05-14 05:00:00	QQQ	ETF	72.96	72.96	72.96	72.96	100.0
2013-05-14 06:00:00	QQQ	ETF	73.01	73.01	72.99	72.99	1100.0
2013-05-14 06:30:00	QQQ	ETF	72.96	72.96	72.94	72.96	5100.0
2013-05-14 07:00:00	QQQ	ETF	72.99	73.0	72.99	72.99	1100.0
2013-05-14 07:30:00	QQQ	ETF	73.02	73.15	73.02	73.15	38295.0
2013-05-14 08:00:00	QQQ	ETF	73.09	73.25	73.09	73.17	19358.0
2013-05-14 08:30:00	QQQ	ETF	73.16	73.2	73.14	73.15	22499.0
2013-05-14 09:00:00	QQQ	ETF	73.16	73.17	73.08	73.12	146264.0
2013-05-14 09:30:00	QQQ	ETF	73.13	73.43	73.13	73.38	2945053.0
2013-05-14 10:00:00	QQQ	ETF	73.37	73.53	73.35	73.5	1821124.0
2013-05-14 10:30:00	QQQ	ETF	73.509	73.67	73.5	73.67	1533783.0
2013-05-14 11:00:00	QQQ	ETF	73.67	73.71	73.59	73.67	1745487.0
2013-05-14 11:30:00	QQQ	ETF	73.67	73.71	73.6	73.64	3406139.0
2013-05-14 12:00:00	QQQ	ETF	73.63	73.74	73.6	73.6	3639126.0
2013-05-14 12:30:00	QQQ	ETF	73.6	73.64	73.5	73.51	2977689.0
2013-05-14 13:00:00	QQQ	ETF	73.51	73.63	73.5	73.56	1844946.0
2013-05-14 13:30:00	QQQ	ETF	73.5675	73.65	73.36	73.41	1539250.0
2013-05-14 14:00:00	QQQ	ETF	73.415	73.48	73.31	73.36	2565133.0

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

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