PREVIEW / etf_30min / 2018-04-17

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-17.parquet
  size:    471 KB
  rows:    16,171

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-04-17 04:00:00	SPY	ETF	268.59	268.8	268.5	268.5	26936.0
2018-04-17 04:30:00	SPY	ETF	268.5	268.86	268.36	268.86	9420.0
2018-04-17 05:00:00	SPY	ETF	268.73	268.79	268.71	268.75	3040.0
2018-04-17 05:30:00	SPY	ETF	268.73	268.87	268.63	268.87	14688.0
2018-04-17 06:00:00	SPY	ETF	268.83	269.0	268.8	268.95	11489.0
2018-04-17 06:30:00	SPY	ETF	269.03	269.17	268.92	269.11	187200.0
2018-04-17 07:00:00	SPY	ETF	269.09	269.09	268.88	268.91	73698.0
2018-04-17 07:30:00	SPY	ETF	268.9	269.08	268.88	269.03	97952.0
2018-04-17 08:00:00	SPY	ETF	269.04	269.35	268.37	269.24	328045.0
2018-04-17 08:30:00	SPY	ETF	269.24	269.37	267.33	269.21	319928.0
2018-04-17 09:00:00	SPY	ETF	269.23	269.44	269.23	269.35	571433.0
2018-04-17 09:30:00	SPY	ETF	269.33	269.43	268.75	269.33	5742359.0
2018-04-17 10:00:00	SPY	ETF	269.34	269.65	269.24	269.39	4175318.0
2018-04-17 10:30:00	SPY	ETF	269.4	270.04	269.36	269.98	3727141.0
2018-04-17 11:00:00	SPY	ETF	269.98	270.36	269.98	270.22	3734796.0
2018-04-17 11:30:00	SPY	ETF	270.23	270.24	269.91	270.02	4837297.0
2018-04-17 12:00:00	SPY	ETF	270.03	270.33	270.03	270.24	1506549.0
2018-04-17 12:30:00	SPY	ETF	270.25	270.28	269.86	270.02	1784321.0
2018-04-17 13:00:00	SPY	ETF	270.02	270.23	269.64	270.07	3075430.0
2018-04-17 13:30:00	SPY	ETF	270.09	270.2	269.81	270.15	2380774.0
2018-04-17 14:00:00	SPY	ETF	270.15	270.43	269.68	269.9	3170449.0
2018-04-17 14:30:00	SPY	ETF	269.9	270.27	269.84	270.13	2487238.0
2018-04-17 15:00:00	SPY	ETF	270.12	270.82	270.02	270.6351	4222540.0
2018-04-17 15:30:00	SPY	ETF	270.64	270.87	270.12	270.15	11956169.0
2018-04-17 16:00:00	SPY	ETF	270.14	270.25	270.08	270.2	6869214.0
2018-04-17 16:30:00	SPY	ETF	270.18	270.28	270.06	270.07	165733.0
2018-04-17 17:00:00	SPY	ETF	270.04	270.19	269.83	269.9	358912.0
2018-04-17 17:30:00	SPY	ETF	269.88	270.1562	269.84	269.9	621025.0
2018-04-17 18:00:00	SPY	ETF	269.91	270.2	269.91	270.2	77846.0
2018-04-17 18:30:00	SPY	ETF	270.19	270.19	270.15	270.18	24199.0
2018-04-17 19:00:00	SPY	ETF	270.2	270.22	270.15	270.18	13047.0
2018-04-17 19:30:00	SPY	ETF	270.18	270.33	270.15	270.25	20797.0
2018-04-17 04:00:00	QQQ	ETF	163.62	163.89	163.6	163.68	45106.0
2018-04-17 04:30:00	QQQ	ETF	163.65	163.94	163.65	163.94	6880.0
2018-04-17 05:00:00	QQQ	ETF	163.83	163.88	163.83	163.88	1100.0
2018-04-17 05:30:00	QQQ	ETF	163.87	164.0	163.74	164.0	19880.0
2018-04-17 06:00:00	QQQ	ETF	164.04	164.11	164.01	164.1	6261.0
2018-04-17 06:30:00	QQQ	ETF	164.03	164.11	164.03	164.05	5830.0
2018-04-17 07:00:00	QQQ	ETF	164.0	164.0	163.9	163.96	17371.0
2018-04-17 07:30:00	QQQ	ETF	163.98	164.13	163.95	164.13	45556.0
2018-04-17 08:00:00	QQQ	ETF	163.96	164.37	163.93	164.25	156758.0
2018-04-17 08:30:00	QQQ	ETF	164.25	164.42	164.25	164.25	176119.0
2018-04-17 09:00:00	QQQ	ETF	164.26	164.38	164.17	164.18	195932.0
2018-04-17 09:30:00	QQQ	ETF	164.19	164.64	163.91	164.5169	3438915.0
2018-04-17 10:00:00	QQQ	ETF	164.53	164.93	164.53	164.71	2341912.0
2018-04-17 10:30:00	QQQ	ETF	164.72	165.21	164.659	165.1899	2092301.0
2018-04-17 11:00:00	QQQ	ETF	165.19	165.741	165.19	165.65	2713775.0
2018-04-17 11:30:00	QQQ	ETF	165.66	165.71	165.455	165.545	2003978.0
2018-04-17 12:00:00	QQQ	ETF	165.56	165.99	165.56	165.94	1287137.0
2018-04-17 12:30:00	QQQ	ETF	165.95	165.97	165.66	165.79	1153557.0

> showing 50 of 16,171 rows — these rows as CSV

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