PREVIEW / etf_30min / 2018-08-09

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-09.parquet
  size:    452 KB
  rows:    15,520

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
2018-08-09 04:00:00	SPY	ETF	285.28	285.35	285.23	285.23	900.0
2018-08-09 04:30:00	SPY	ETF	285.26	285.45	285.23	285.45	5702.0
2018-08-09 05:00:00	SPY	ETF	285.46	285.47	285.41	285.46	7900.0
2018-08-09 05:30:00	SPY	ETF	285.39	285.49	285.39	285.41	4600.0
2018-08-09 06:00:00	SPY	ETF	285.44	285.7	285.41	285.7	10302.0
2018-08-09 06:30:00	SPY	ETF	285.62	285.62	285.35	285.39	5000.0
2018-08-09 07:00:00	SPY	ETF	285.39	285.45	285.35	285.4	17100.0
2018-08-09 07:30:00	SPY	ETF	285.4	285.59	285.36	285.59	28727.0
2018-08-09 08:00:00	SPY	ETF	285.38	285.58	285.2	285.58	44759.0
2018-08-09 08:30:00	SPY	ETF	285.58	285.59	285.51	285.58	1037060.0
2018-08-09 09:00:00	SPY	ETF	285.6	285.71	285.46	285.53	164300.0
2018-08-09 09:30:00	SPY	ETF	285.53	285.67	285.32	285.5098	3384235.0
2018-08-09 10:00:00	SPY	ETF	285.5	285.87	285.465	285.81	2920925.0
2018-08-09 10:30:00	SPY	ETF	285.82	285.97	285.71	285.73	1970912.0
2018-08-09 11:00:00	SPY	ETF	285.74	285.925	285.61	285.74	2251038.0
2018-08-09 11:30:00	SPY	ETF	285.74	285.76	285.21	285.345	2321759.0
2018-08-09 12:00:00	SPY	ETF	285.35	285.57	285.32	285.5	1834023.0
2018-08-09 12:30:00	SPY	ETF	285.5	285.77	285.4942	285.72	1068920.0
2018-08-09 13:00:00	SPY	ETF	285.72	285.79	285.59	285.76	958750.0
2018-08-09 13:30:00	SPY	ETF	285.76	285.86	285.735	285.79	948382.0
2018-08-09 14:00:00	SPY	ETF	285.78	285.79	285.55	285.64	1466933.0
2018-08-09 14:30:00	SPY	ETF	285.64	285.79	285.59	285.605	1372881.0
2018-08-09 15:00:00	SPY	ETF	285.61	285.65	285.5	285.515	1957885.0
2018-08-09 15:30:00	SPY	ETF	285.51	285.57	284.915	285.06	7824730.0
2018-08-09 16:00:00	SPY	ETF	285.05	285.6686	285.0	285.08	3107061.0
2018-08-09 16:30:00	SPY	ETF	285.08	285.11	284.76	284.93	306578.0
2018-08-09 17:00:00	SPY	ETF	284.97	285.0	284.9	284.9	40091.0
2018-08-09 17:30:00	SPY	ETF	284.9	284.94	284.83	284.86	30903.0
2018-08-09 18:00:00	SPY	ETF	284.89	284.98	284.73	284.75	70343.0
2018-08-09 18:30:00	SPY	ETF	284.77	284.78	284.7	284.76	16022.0
2018-08-09 19:00:00	SPY	ETF	284.74	284.83	284.74	284.83	12652.0
2018-08-09 19:30:00	SPY	ETF	284.81	284.92	284.8	284.82	13727.0
2018-08-09 04:00:00	QQQ	ETF	181.79	181.92	181.74	181.76	3891.0
2018-08-09 04:30:00	QQQ	ETF	181.77	181.92	181.77	181.92	6300.0
2018-08-09 05:00:00	QQQ	ETF	181.93	182.0	181.93	181.96	1470.0
2018-08-09 05:30:00	QQQ	ETF	181.98	182.02	181.88	181.94	7100.0
2018-08-09 06:00:00	QQQ	ETF	181.94	182.2	181.94	182.1	9061.0
2018-08-09 06:30:00	QQQ	ETF	182.03	182.06	181.83	181.85	8550.0
2018-08-09 07:00:00	QQQ	ETF	181.85	181.99	181.85	181.94	36818.0
2018-08-09 07:30:00	QQQ	ETF	181.94	181.97	181.79	181.89	42730.0
2018-08-09 08:00:00	QQQ	ETF	181.9601	182.09	181.82	181.92	49262.0
2018-08-09 08:30:00	QQQ	ETF	181.91	181.97	181.84	181.91	45106.0
2018-08-09 09:00:00	QQQ	ETF	181.95	182.05	181.88	181.95	106229.0
2018-08-09 09:30:00	QQQ	ETF	181.94	182.23	181.64	181.9459	2499902.0
2018-08-09 10:00:00	QQQ	ETF	181.95	182.4475	181.92	182.4	1208185.0
2018-08-09 10:30:00	QQQ	ETF	182.4	182.53	182.246	182.26	1140888.0
2018-08-09 11:00:00	QQQ	ETF	182.27	182.44	182.11	182.34	855935.0
2018-08-09 11:30:00	QQQ	ETF	182.33	182.41	181.98	182.11	1079512.0
2018-08-09 12:00:00	QQQ	ETF	182.11	182.32	182.1	182.2642	486109.0
2018-08-09 12:30:00	QQQ	ETF	182.265	182.4498	182.25	182.4225	657441.0

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

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