PREVIEW / etf_30min / 2017-10-26

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-26.parquet
  size:    448 KB
  rows:    15,548

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-10-26 04:00:00	SPY	ETF	255.65	255.65	255.61	255.61	600.0
2017-10-26 04:30:00	SPY	ETF	255.61	255.61	255.5	255.5	4000.0
2017-10-26 05:00:00	SPY	ETF	255.5	255.5	255.5	255.5	600.0
2017-10-26 05:30:00	SPY	ETF	255.5	255.53	255.48	255.53	40200.0
2017-10-26 06:00:00	SPY	ETF	255.61	255.75	255.61	255.75	9700.0
2017-10-26 06:30:00	SPY	ETF	255.74	255.88	255.72	255.87	21900.0
2017-10-26 07:00:00	SPY	ETF	255.85	256.06	255.83	256.03	91957.0
2017-10-26 07:30:00	SPY	ETF	256.0	256.14	255.97	256.0	141856.0
2017-10-26 08:00:00	SPY	ETF	256.0	256.12	255.6	255.98	296864.0
2017-10-26 08:30:00	SPY	ETF	255.98	256.06	255.86	255.92	281384.0
2017-10-26 09:00:00	SPY	ETF	255.87	256.03	255.82	255.99	416321.0
2017-10-26 09:30:00	SPY	ETF	255.99	256.2	255.84	256.035	7514323.0
2017-10-26 10:00:00	SPY	ETF	256.04	256.05	255.56	255.78	3631290.0
2017-10-26 10:30:00	SPY	ETF	255.79	256.16	255.71	256.11	4023745.0
2017-10-26 11:00:00	SPY	ETF	256.11	256.3	255.69	255.95	6569808.0
2017-10-26 11:30:00	SPY	ETF	255.95	256.08	255.8	255.93	3384112.0
2017-10-26 12:00:00	SPY	ETF	255.93	256.14	255.9	256.125	2396980.0
2017-10-26 12:30:00	SPY	ETF	256.125	256.125	255.68	255.7646	2709755.0
2017-10-26 13:00:00	SPY	ETF	255.76	256.04	255.6801	255.9742	2406174.0
2017-10-26 13:30:00	SPY	ETF	255.98	256.04	255.86	256.02	1461005.0
2017-10-26 14:00:00	SPY	ETF	256.02	256.1	255.96	256.04	1394159.0
2017-10-26 14:30:00	SPY	ETF	256.04	256.0852	255.76	255.77	1873096.0
2017-10-26 15:00:00	SPY	ETF	255.77	255.87	255.62	255.77	7855337.0
2017-10-26 15:30:00	SPY	ETF	255.78	255.92	255.58	255.59	10478156.0
2017-10-26 16:00:00	SPY	ETF	255.6	256.1	255.4	256.02	7310776.0
2017-10-26 16:30:00	SPY	ETF	256.03	256.13	255.62	256.04	978992.0
2017-10-26 17:00:00	SPY	ETF	256.04	256.1	256.0	256.08	88298.0
2017-10-26 17:30:00	SPY	ETF	256.08	256.08	256.03	256.03	30875.0
2017-10-26 18:00:00	SPY	ETF	256.02	256.06	255.96	256.0	61457.0
2017-10-26 18:30:00	SPY	ETF	255.98	256.02	255.97	255.99	7062.0
2017-10-26 19:00:00	SPY	ETF	255.99	256.01	255.97	255.98	43877.0
2017-10-26 19:30:00	SPY	ETF	255.98	256.02	255.98	256.02	18614.0
2017-10-26 04:00:00	QQQ	ETF	147.68	147.68	147.68	147.68	5000.0
2017-10-26 04:30:00	QQQ	ETF	147.69	147.69	147.59	147.59	5200.0
2017-10-26 05:00:00	QQQ	ETF	147.59	147.59	147.59	147.59	500.0
2017-10-26 05:30:00	QQQ	ETF	147.58	147.65	147.58	147.62	28700.0
2017-10-26 06:00:00	QQQ	ETF	147.68	147.75	147.68	147.73	3900.0
2017-10-26 06:30:00	QQQ	ETF	147.73	147.8	147.73	147.77	4820.0
2017-10-26 07:00:00	QQQ	ETF	147.77	147.9	147.77	147.88	26905.0
2017-10-26 07:30:00	QQQ	ETF	147.91	147.91	147.68	147.7	26838.0
2017-10-26 08:00:00	QQQ	ETF	147.72	147.79	147.53	147.6	129860.0
2017-10-26 08:30:00	QQQ	ETF	147.61	147.66	147.42	147.45	223342.0
2017-10-26 09:00:00	QQQ	ETF	147.43	147.54	147.33	147.38	433442.0
2017-10-26 09:30:00	QQQ	ETF	147.36	147.59	147.14	147.33	2563157.0
2017-10-26 10:00:00	QQQ	ETF	147.34	147.37	146.92	147.2366	2413340.0
2017-10-26 10:30:00	QQQ	ETF	147.23	147.6452	147.19	147.57	1180719.0
2017-10-26 11:00:00	QQQ	ETF	147.56	147.705	147.22	147.28	1376528.0
2017-10-26 11:30:00	QQQ	ETF	147.27	147.38	147.185	147.34	787423.0
2017-10-26 12:00:00	QQQ	ETF	147.3499	147.48	147.28	147.34	383598.0
2017-10-26 12:30:00	QQQ	ETF	147.33	147.33	147.1	147.181	609676.0

> showing 50 of 15,548 rows — these rows as CSV

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