PREVIEW / etf_30min / 2018-03-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-23.parquet
  size:    489 KB
  rows:    16,915

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-03-23 04:00:00	SPY	ETF	263.39	263.86	262.79	262.79	29848.0
2018-03-23 04:30:00	SPY	ETF	262.86	262.86	262.43	262.56	14057.0
2018-03-23 05:00:00	SPY	ETF	262.5	262.71	261.99	261.99	23374.0
2018-03-23 05:30:00	SPY	ETF	261.99	262.11	261.66	261.86	34661.0
2018-03-23 06:00:00	SPY	ETF	261.84	262.33	261.63	262.29	45860.0
2018-03-23 06:30:00	SPY	ETF	262.33	262.9	262.33	262.85	53046.0
2018-03-23 07:00:00	SPY	ETF	262.88	263.06	262.64	262.85	113908.0
2018-03-23 07:30:00	SPY	ETF	262.8	263.56	262.68	263.52	357239.0
2018-03-23 08:00:00	SPY	ETF	263.5	264.3	261.72	264.0	1613648.0
2018-03-23 08:30:00	SPY	ETF	263.93	264.34	263.34	263.4	689266.0
2018-03-23 09:00:00	SPY	ETF	263.43	264.36	263.38	264.14	730834.0
2018-03-23 09:30:00	SPY	ETF	264.17	265.02	263.25	263.955	10363450.0
2018-03-23 10:00:00	SPY	ETF	263.9401	264.58	263.35	264.07	9743664.0
2018-03-23 10:30:00	SPY	ETF	264.09	264.6	263.8161	264.51	10651684.0
2018-03-23 11:00:00	SPY	ETF	264.49	264.74	263.45	263.5	5585824.0
2018-03-23 11:30:00	SPY	ETF	263.51	263.72	261.76	261.84	8107125.0
2018-03-23 12:00:00	SPY	ETF	261.83	263.12	261.77	263.05	6732115.0
2018-03-23 12:30:00	SPY	ETF	263.04	263.08	261.88	262.06	8068242.0
2018-03-23 13:00:00	SPY	ETF	262.07	263.45	261.81	263.21	6595521.0
2018-03-23 13:30:00	SPY	ETF	263.26	264.1	262.705	263.82	5994596.0
2018-03-23 14:00:00	SPY	ETF	263.83	264.14	262.105	262.435	8469198.0
2018-03-23 14:30:00	SPY	ETF	262.43	262.5686	260.08	260.21	11561558.0
2018-03-23 15:00:00	SPY	ETF	260.21	260.71	259.39	259.88	20364533.0
2018-03-23 15:30:00	SPY	ETF	259.88	260.8	257.83	258.01	37228255.0
2018-03-23 16:00:00	SPY	ETF	258.0	259.35	257.97	258.86	20853265.0
2018-03-23 16:30:00	SPY	ETF	258.89	259.54	258.05	258.85	3982640.0
2018-03-23 17:00:00	SPY	ETF	258.95	258.95	258.05	258.16	2296111.0
2018-03-23 17:30:00	SPY	ETF	258.21	258.36	258.13	258.24	126603.0
2018-03-23 18:00:00	SPY	ETF	258.24	258.66	258.13	258.6	44240.0
2018-03-23 18:30:00	SPY	ETF	258.54	258.55	258.35	258.5	49216.0
2018-03-23 19:00:00	SPY	ETF	258.49	258.69	258.4	258.6	33531.0
2018-03-23 19:30:00	SPY	ETF	258.6	258.8	258.57	258.65	70333.0
2018-03-23 04:00:00	QQQ	ETF	161.97	162.18	161.47	161.54	17353.0
2018-03-23 04:30:00	QQQ	ETF	161.44	161.52	161.16	161.3	12901.0
2018-03-23 05:00:00	QQQ	ETF	161.31	161.42	160.93	161.02	11740.0
2018-03-23 05:30:00	QQQ	ETF	161.0	161.01	160.7	160.88	36950.0
2018-03-23 06:00:00	QQQ	ETF	160.86	161.24	160.71	160.99	57856.0
2018-03-23 06:30:00	QQQ	ETF	161.07	161.48	161.07	161.43	47162.0
2018-03-23 07:00:00	QQQ	ETF	161.43	161.79	161.39	161.66	108848.0
2018-03-23 07:30:00	QQQ	ETF	161.65	162.08	161.57	162.08	129108.0
2018-03-23 08:00:00	QQQ	ETF	162.05	162.67	161.44	162.39	329927.0
2018-03-23 08:30:00	QQQ	ETF	162.45	162.88	162.17	162.24	533178.0
2018-03-23 09:00:00	QQQ	ETF	162.2	162.85	162.17	162.62	449381.0
2018-03-23 09:30:00	QQQ	ETF	162.6	163.3	161.61	162.43	6063219.0
2018-03-23 10:00:00	QQQ	ETF	162.44	162.82	161.89	162.42	4080870.0
2018-03-23 10:30:00	QQQ	ETF	162.41	163.13	162.24	163.089	3256011.0
2018-03-23 11:00:00	QQQ	ETF	163.07	163.22	162.08	162.11	2567871.0
2018-03-23 11:30:00	QQQ	ETF	162.11	162.36	160.92	160.97	3471439.0
2018-03-23 12:00:00	QQQ	ETF	160.97	161.83	160.94	161.76	2429201.0
2018-03-23 12:30:00	QQQ	ETF	161.76	161.8	160.96	161.07	2270451.0

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

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