PREVIEW / etf_30min / 2014-06-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-13.parquet
  size:    323 KB
  rows:    11,224

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-06-13 04:00:00	SPY	ETF	193.6	193.9	193.59	193.9	1528.0
2014-06-13 04:30:00	SPY	ETF	193.83	193.9	193.79	193.9	2966.0
2014-06-13 05:00:00	SPY	ETF	193.78	193.79	193.72	193.74	2023.0
2014-06-13 05:30:00	SPY	ETF	193.67	193.67	193.53	193.53	3424.0
2014-06-13 06:00:00	SPY	ETF	193.5	193.58	193.46	193.46	6153.0
2014-06-13 06:30:00	SPY	ETF	193.46	193.49	193.3	193.34	70166.0
2014-06-13 07:00:00	SPY	ETF	193.35	193.42	193.2	193.38	65036.0
2014-06-13 07:30:00	SPY	ETF	193.37	193.6	193.34	193.58	400286.0
2014-06-13 08:00:00	SPY	ETF	193.43	193.62	193.34	193.5	550548.0
2014-06-13 08:30:00	SPY	ETF	193.5	193.67	193.36	193.67	1355621.0
2014-06-13 09:00:00	SPY	ETF	193.68	193.98	193.68	193.91	976093.0
2014-06-13 09:30:00	SPY	ETF	193.9	193.94	193.44	193.625	8521163.0
2014-06-13 10:00:00	SPY	ETF	193.62	194.05	193.3	193.96	8293181.0
2014-06-13 10:30:00	SPY	ETF	193.96	194.3	193.94	194.2	4563295.0
2014-06-13 11:00:00	SPY	ETF	194.2	194.32	194.06	194.08	2924510.0
2014-06-13 11:30:00	SPY	ETF	194.08	194.12	193.83	193.93	3174560.0
2014-06-13 12:00:00	SPY	ETF	193.93	194.15	193.91	194.09	2085283.0
2014-06-13 12:30:00	SPY	ETF	194.08	194.09	193.86	193.901	2397477.0
2014-06-13 13:00:00	SPY	ETF	193.9	194.03	193.79	193.92	3285355.0
2014-06-13 13:30:00	SPY	ETF	193.92	194.06	193.83	194.03	2785012.0
2014-06-13 14:00:00	SPY	ETF	194.03	194.17	193.98	194.115	1882880.0
2014-06-13 14:30:00	SPY	ETF	194.115	194.14	194.01	194.07	1755791.0
2014-06-13 15:00:00	SPY	ETF	194.065	194.32	193.76	193.7975	10539463.0
2014-06-13 15:30:00	SPY	ETF	193.8	194.15	193.68	194.14	12492432.0
2014-06-13 16:00:00	SPY	ETF	194.14	194.28	194.06	194.19	7363235.0
2014-06-13 16:30:00	SPY	ETF	194.19	194.2	194.14	194.2	5178205.0
2014-06-13 17:00:00	SPY	ETF	194.2	194.21	194.13	194.19	147108.0
2014-06-13 17:30:00	SPY	ETF	194.19	194.19	194.14	194.19	21526.0
2014-06-13 18:00:00	SPY	ETF	194.17	194.18	194.17	194.18	1650.0
2014-06-13 18:30:00	SPY	ETF	194.17	194.18	194.17	194.18	10025.0
2014-06-13 19:00:00	SPY	ETF	194.18	194.18	194.17	194.18	2305.0
2014-06-13 19:30:00	SPY	ETF	194.17	194.2	194.17	194.2	11039.0
2014-06-13 04:00:00	QQQ	ETF	92.16	92.25	92.16	92.25	5500.0
2014-06-13 04:30:00	QQQ	ETF	92.28	92.28	92.28	92.28	2500.0
2014-06-13 06:00:00	QQQ	ETF	92.08	92.18	92.08	92.18	750.0
2014-06-13 06:30:00	QQQ	ETF	92.1	92.15	92.1	92.15	2800.0
2014-06-13 07:00:00	QQQ	ETF	92.14	92.15	92.09	92.14	19190.0
2014-06-13 07:30:00	QQQ	ETF	92.15	92.26	92.15	92.25	254500.0
2014-06-13 08:00:00	QQQ	ETF	92.23	92.26	92.2	92.23	141942.0
2014-06-13 08:30:00	QQQ	ETF	92.23	92.31	92.13	92.31	212159.0
2014-06-13 09:00:00	QQQ	ETF	92.32	92.47	92.32	92.47	323609.0
2014-06-13 09:30:00	QQQ	ETF	92.47	92.48	92.11	92.23	6828325.0
2014-06-13 10:00:00	QQQ	ETF	92.23	92.39	91.92	92.359	4238298.0
2014-06-13 10:30:00	QQQ	ETF	92.36	92.52	92.32	92.52	1747009.0
2014-06-13 11:00:00	QQQ	ETF	92.52	92.55	92.35	92.39	1071617.0
2014-06-13 11:30:00	QQQ	ETF	92.39	92.4	92.17	92.23	845551.0
2014-06-13 12:00:00	QQQ	ETF	92.23	92.4	92.2106	92.35	775256.0
2014-06-13 12:30:00	QQQ	ETF	92.355	92.365	92.21	92.22	795254.0
2014-06-13 13:00:00	QQQ	ETF	92.219	92.28	92.15	92.2	1097137.0
2014-06-13 13:30:00	QQQ	ETF	92.21	92.32	92.169	92.31	783489.0

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

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