PREVIEW / etf_30min / 2013-06-14

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-14.parquet
  size:    314 KB
  rows:    10,694

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-14 04:00:00	SPY	ETF	164.22	164.35	164.22	164.24	4650.0
2013-06-14 04:30:00	SPY	ETF	164.29	164.37	164.17	164.37	12400.0
2013-06-14 05:00:00	SPY	ETF	164.39	164.42	164.02	164.12	98100.0
2013-06-14 05:30:00	SPY	ETF	164.14	164.22	163.94	163.96	72300.0
2013-06-14 06:00:00	SPY	ETF	163.92	164.03	163.85	164.03	27670.0
2013-06-14 06:30:00	SPY	ETF	164.0	164.0	163.83	163.92	34310.0
2013-06-14 07:00:00	SPY	ETF	163.9	164.23	163.9	164.15	181785.0
2013-06-14 07:30:00	SPY	ETF	164.16	164.22	164.09	164.09	180068.0
2013-06-14 08:00:00	SPY	ETF	164.09	164.23	163.87	163.92	351776.0
2013-06-14 08:30:00	SPY	ETF	163.9	164.12	163.9	164.06	437565.0
2013-06-14 09:00:00	SPY	ETF	164.06	164.14	163.94	164.04	738759.0
2013-06-14 09:30:00	SPY	ETF	164.03	164.48	163.89	164.45	11990922.0
2013-06-14 10:00:00	SPY	ETF	164.45	164.67	164.1	164.15	9274858.0
2013-06-14 10:30:00	SPY	ETF	164.15	164.28	163.46	163.57	9492710.0
2013-06-14 11:00:00	SPY	ETF	163.57	163.86	163.38	163.78	9005329.0
2013-06-14 11:30:00	SPY	ETF	163.78	163.915	163.31	163.67	8779398.0
2013-06-14 12:00:00	SPY	ETF	163.67	163.76	163.41	163.63	5579371.0
2013-06-14 12:30:00	SPY	ETF	163.635	163.83	163.35	163.43	5809318.0
2013-06-14 13:00:00	SPY	ETF	163.42	163.42	162.96	163.04	7435191.0
2013-06-14 13:30:00	SPY	ETF	163.03	163.19	162.95	163.131	7122445.0
2013-06-14 14:00:00	SPY	ETF	163.11	163.63	162.91	163.51	8755741.0
2013-06-14 14:30:00	SPY	ETF	163.5	163.61	163.13	163.2	5120400.0
2013-06-14 15:00:00	SPY	ETF	163.19	163.73	163.17	163.4301	7359575.0
2013-06-14 15:30:00	SPY	ETF	163.43	163.58	163.03	163.18	18104352.0
2013-06-14 16:00:00	SPY	ETF	163.19	163.5855	162.99	163.04	17830675.0
2013-06-14 16:30:00	SPY	ETF	163.04	163.08	162.99	163.0	2291923.0
2013-06-14 17:00:00	SPY	ETF	163.01	163.01	162.98	163.0	355848.0
2013-06-14 17:30:00	SPY	ETF	162.99	163.02	162.95	162.96	19947.0
2013-06-14 18:00:00	SPY	ETF	162.95	162.96	162.91	162.92	30229.0
2013-06-14 18:30:00	SPY	ETF	162.92	163.05	162.7	162.83	102259.0
2013-06-14 19:00:00	SPY	ETF	162.83	162.9	162.82	162.89	20422.0
2013-06-14 19:30:00	SPY	ETF	162.91	162.93	162.875	162.93	26459.0
2013-06-14 04:00:00	QQQ	ETF	72.82	72.82	72.78	72.78	1800.0
2013-06-14 04:30:00	QQQ	ETF	72.8	72.82	72.76	72.82	2000.0
2013-06-14 05:00:00	QQQ	ETF	72.84	72.84	72.7	72.72	2600.0
2013-06-14 05:30:00	QQQ	ETF	72.74	72.78	72.66	72.66	1800.0
2013-06-14 06:00:00	QQQ	ETF	72.64	72.7	72.64	72.68	1400.0
2013-06-14 06:30:00	QQQ	ETF	72.66	72.66	72.57	72.64	4200.0
2013-06-14 07:00:00	QQQ	ETF	72.63	72.74	72.63	72.69	7200.0
2013-06-14 07:30:00	QQQ	ETF	72.68	72.74	72.68	72.72	5995.0
2013-06-14 08:00:00	QQQ	ETF	72.73	72.73	72.66	72.67	16238.0
2013-06-14 08:30:00	QQQ	ETF	72.69	72.77	72.66	72.76	32368.0
2013-06-14 09:00:00	QQQ	ETF	72.73	72.78	72.68	72.74	68112.0
2013-06-14 09:30:00	QQQ	ETF	72.76	72.82	72.6	72.789	2841811.0
2013-06-14 10:00:00	QQQ	ETF	72.79	72.84	72.6	72.67	2891232.0
2013-06-14 10:30:00	QQQ	ETF	72.67	72.72	72.34	72.39	2569373.0
2013-06-14 11:00:00	QQQ	ETF	72.39	72.46	72.32	72.42	1931102.0
2013-06-14 11:30:00	QQQ	ETF	72.43	72.4901	72.25	72.41	1708234.0
2013-06-14 12:00:00	QQQ	ETF	72.41	72.575	72.32	72.53	1774851.0
2013-06-14 12:30:00	QQQ	ETF	72.54	72.61	72.37	72.41	1257974.0

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

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