PREVIEW / etf_30min / 2017-04-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-07.parquet
  size:    420 KB
  rows:    14,303

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
2017-04-07 04:00:00	SPY	ETF	235.1	235.15	234.96	235.0	3100.0
2017-04-07 04:30:00	SPY	ETF	234.99	235.12	234.91	235.04	26100.0
2017-04-07 05:00:00	SPY	ETF	235.0	235.02	234.76	234.8	4345.0
2017-04-07 05:30:00	SPY	ETF	234.7	234.8	234.7	234.8	7005.0
2017-04-07 06:00:00	SPY	ETF	234.91	235.04	234.83	235.04	30086.0
2017-04-07 06:30:00	SPY	ETF	235.03	235.33	235.01	235.18	88798.0
2017-04-07 07:00:00	SPY	ETF	235.23	235.45	235.2	235.45	408991.0
2017-04-07 07:30:00	SPY	ETF	235.44	235.52	235.22	235.23	137168.0
2017-04-07 08:00:00	SPY	ETF	235.25	235.38	234.93	235.13	318773.0
2017-04-07 08:30:00	SPY	ETF	235.12	235.14	234.53	234.92	1354446.0
2017-04-07 09:00:00	SPY	ETF	234.92	235.28	234.86	235.14	674154.0
2017-04-07 09:30:00	SPY	ETF	235.15	235.7	234.66	234.73	9395013.0
2017-04-07 10:00:00	SPY	ETF	234.73	235.46	234.64	235.37	6073285.0
2017-04-07 10:30:00	SPY	ETF	235.38	235.55	235.09	235.185	4220698.0
2017-04-07 11:00:00	SPY	ETF	235.185	235.36	234.91	235.21	4522629.0
2017-04-07 11:30:00	SPY	ETF	235.2	235.35	235.04	235.28	2233702.0
2017-04-07 12:00:00	SPY	ETF	235.28	235.52	235.25	235.42	2370957.0
2017-04-07 12:30:00	SPY	ETF	235.42	235.57	235.305	235.52	2429341.0
2017-04-07 13:00:00	SPY	ETF	235.52	235.82	235.345	235.77	3133671.0
2017-04-07 13:30:00	SPY	ETF	235.77	236.0	235.63	235.7	3283959.0
2017-04-07 14:00:00	SPY	ETF	235.7	235.9	235.69	235.71	2298081.0
2017-04-07 14:30:00	SPY	ETF	235.71	235.75	235.42	235.43	3241958.0
2017-04-07 15:00:00	SPY	ETF	235.42	235.62	235.37	235.385	3135689.0
2017-04-07 15:30:00	SPY	ETF	235.38	235.41	235.1	235.17	9888497.0
2017-04-07 16:00:00	SPY	ETF	235.16	235.28	235.12	235.16	12969486.0
2017-04-07 16:30:00	SPY	ETF	235.2	235.23	235.12	235.19	263201.0
2017-04-07 17:00:00	SPY	ETF	235.19	235.26	235.1	235.14	102002.0
2017-04-07 17:30:00	SPY	ETF	235.13	235.26	235.13	235.2	29891.0
2017-04-07 18:00:00	SPY	ETF	235.16	235.29	235.16	235.23	17213.0
2017-04-07 18:30:00	SPY	ETF	235.23	235.23	235.21	235.22	12341.0
2017-04-07 19:00:00	SPY	ETF	235.26	235.26	235.21	235.21	1521.0
2017-04-07 19:30:00	SPY	ETF	235.23	235.23	235.16	235.19	13259.0
2017-04-07 05:00:00	QQQ	ETF	131.77	131.77	131.77	131.77	1000.0
2017-04-07 05:30:00	QQQ	ETF	131.83	131.85	131.83	131.85	10000.0
2017-04-07 06:00:00	QQQ	ETF	131.85	131.85	131.85	131.85	250.0
2017-04-07 06:30:00	QQQ	ETF	131.94	132.04	131.94	131.98	8233.0
2017-04-07 07:00:00	QQQ	ETF	132.05	132.13	132.03	132.13	13482.0
2017-04-07 07:30:00	QQQ	ETF	132.16	132.16	132.02	132.02	14450.0
2017-04-07 08:00:00	QQQ	ETF	132.04	132.06	131.85	131.95	35432.0
2017-04-07 08:30:00	QQQ	ETF	131.94	131.94	131.63	131.89	232635.0
2017-04-07 09:00:00	QQQ	ETF	131.89	132.06	131.86	131.99	155626.0
2017-04-07 09:30:00	QQQ	ETF	131.99	132.27	131.52	131.58	3204207.0
2017-04-07 10:00:00	QQQ	ETF	131.57	132.025	131.5	131.97	1913395.0
2017-04-07 10:30:00	QQQ	ETF	131.97	132.135	131.86	131.905	1190711.0
2017-04-07 11:00:00	QQQ	ETF	131.91	132.03	131.75	131.94	817013.0
2017-04-07 11:30:00	QQQ	ETF	131.96	132.03	131.85	131.9634	633659.0
2017-04-07 12:00:00	QQQ	ETF	131.96	132.15	131.96	132.12	415588.0
2017-04-07 12:30:00	QQQ	ETF	132.12	132.22	132.065	132.1947	495600.0
2017-04-07 13:00:00	QQQ	ETF	132.19	132.28	132.09	132.26	655665.0
2017-04-07 13:30:00	QQQ	ETF	132.26	132.37	132.17	132.201	1038215.0

> showing 50 of 14,303 rows — these rows as CSV

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