PREVIEW / etf_30min / 2017-10-18

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-18.parquet
  size:    437 KB
  rows:    15,267

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-18 04:00:00	SPY	ETF	255.5	255.5	255.49	255.49	5000.0
2017-10-18 05:00:00	SPY	ETF	255.54	255.57	255.54	255.57	3500.0
2017-10-18 05:30:00	SPY	ETF	255.57	255.77	255.57	255.77	9780.0
2017-10-18 06:00:00	SPY	ETF	255.73	255.73	255.67	255.72	3100.0
2017-10-18 06:30:00	SPY	ETF	255.73	255.83	255.73	255.83	14200.0
2017-10-18 07:00:00	SPY	ETF	255.85	255.86	255.8	255.82	36518.0
2017-10-18 07:30:00	SPY	ETF	255.83	255.85	255.79	255.82	32223.0
2017-10-18 08:00:00	SPY	ETF	255.81	255.92	255.75	255.9	687162.0
2017-10-18 08:30:00	SPY	ETF	255.88	255.89	255.82	255.83	114320.0
2017-10-18 09:00:00	SPY	ETF	255.83	255.98	255.83	255.91	260492.0
2017-10-18 09:30:00	SPY	ETF	255.9	255.93	255.64	255.72	4145007.0
2017-10-18 10:00:00	SPY	ETF	255.7189	255.8	255.5	255.66	2299810.0
2017-10-18 10:30:00	SPY	ETF	255.66	255.78	255.6	255.68	2334595.0
2017-10-18 11:00:00	SPY	ETF	255.68	255.73	255.5	255.63	2621499.0
2017-10-18 11:30:00	SPY	ETF	255.63	255.71	255.59	255.62	2099305.0
2017-10-18 12:00:00	SPY	ETF	255.62	255.82	255.6	255.785	1076368.0
2017-10-18 12:30:00	SPY	ETF	255.78	255.84	255.75	255.77	1040511.0
2017-10-18 13:00:00	SPY	ETF	255.77	255.88	255.77	255.84	1317436.0
2017-10-18 13:30:00	SPY	ETF	255.83	255.95	255.8	255.875	2971932.0
2017-10-18 14:00:00	SPY	ETF	255.875	255.95	255.83	255.85	2093755.0
2017-10-18 14:30:00	SPY	ETF	255.85	255.88	255.7701	255.79	759980.0
2017-10-18 15:00:00	SPY	ETF	255.79	255.92	255.78	255.89	2034642.0
2017-10-18 15:30:00	SPY	ETF	255.88	255.93	255.58	255.69	6659168.0
2017-10-18 16:00:00	SPY	ETF	255.69	255.79	255.65	255.73	6563854.0
2017-10-18 16:30:00	SPY	ETF	255.74	255.8	255.72	255.76	357603.0
2017-10-18 17:00:00	SPY	ETF	255.76	255.84	255.6625	255.75	185753.0
2017-10-18 17:30:00	SPY	ETF	255.78	255.79	255.75	255.78	71012.0
2017-10-18 18:00:00	SPY	ETF	255.77	255.77	255.74	255.76	94240.0
2017-10-18 18:30:00	SPY	ETF	255.75	255.75	255.69	255.72	81056.0
2017-10-18 19:00:00	SPY	ETF	255.73	255.75	255.73	255.73	8282.0
2017-10-18 19:30:00	SPY	ETF	255.73	255.76	255.73	255.76	21054.0
2017-10-18 04:00:00	QQQ	ETF	149.02	149.05	149.02	149.05	5100.0
2017-10-18 04:30:00	QQQ	ETF	149.02	149.02	149.02	149.02	400.0
2017-10-18 05:00:00	QQQ	ETF	149.01	149.04	149.01	149.04	1200.0
2017-10-18 05:30:00	QQQ	ETF	149.2	149.2	149.2	149.2	2500.0
2017-10-18 06:00:00	QQQ	ETF	149.14	149.14	149.14	149.14	100.0
2017-10-18 06:30:00	QQQ	ETF	149.14	149.17	149.14	149.17	600.0
2017-10-18 07:00:00	QQQ	ETF	149.19	149.19	149.14	149.16	6100.0
2017-10-18 07:30:00	QQQ	ETF	149.13	149.15	149.12	149.12	10024.0
2017-10-18 08:00:00	QQQ	ETF	149.04	149.21	149.04	149.21	34943.0
2017-10-18 08:30:00	QQQ	ETF	149.17	149.17	149.04	149.16	18887.0
2017-10-18 09:00:00	QQQ	ETF	149.17	149.24	149.17	149.2	77665.0
2017-10-18 09:30:00	QQQ	ETF	149.21	149.21	148.77	148.8352	2578340.0
2017-10-18 10:00:00	QQQ	ETF	148.85	148.92	148.64	148.87	2379645.0
2017-10-18 10:30:00	QQQ	ETF	148.87	149.05	148.87	148.96	960412.0
2017-10-18 11:00:00	QQQ	ETF	148.95	148.98	148.79	148.89	1384323.0
2017-10-18 11:30:00	QQQ	ETF	148.9	148.93	148.83	148.84	521634.0
2017-10-18 12:00:00	QQQ	ETF	148.83	149.06	148.82	149.035	555770.0
2017-10-18 12:30:00	QQQ	ETF	149.04	149.13	149.0233	149.05	618414.0
2017-10-18 13:00:00	QQQ	ETF	149.05	149.09	149.0	149.0157	362919.0

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

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