PREVIEW / etf_30min / 2019-11-27

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-27.parquet
  size:    507 KB
  rows:    17,727

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
2019-11-27 04:00:00	SPY	ETF	314.89	315.09	314.85	315.08	7605.0
2019-11-27 04:30:00	SPY	ETF	315.05	315.05	314.95	315.02	4440.0
2019-11-27 05:00:00	SPY	ETF	315.05	315.13	315.0	315.02	7221.0
2019-11-27 05:30:00	SPY	ETF	315.0	315.1	315.0	315.05	7535.0
2019-11-27 06:00:00	SPY	ETF	315.05	315.05	314.9	314.93	14939.0
2019-11-27 06:30:00	SPY	ETF	314.88	314.93	314.78	314.78	6239.0
2019-11-27 07:00:00	SPY	ETF	314.78	314.9	314.76	314.83	23086.0
2019-11-27 07:30:00	SPY	ETF	314.81	314.88	314.75	314.88	45473.0
2019-11-27 08:00:00	SPY	ETF	314.8	315.0	314.63	314.8	81733.0
2019-11-27 08:30:00	SPY	ETF	314.84	315.03	314.68	314.68	220692.0
2019-11-27 09:00:00	SPY	ETF	314.7	314.76	314.6	314.64	177010.0
2019-11-27 09:30:00	SPY	ETF	314.61	314.7	314.37	314.61	3245328.0
2019-11-27 10:00:00	SPY	ETF	314.62	314.62	314.37	314.52	4141199.0
2019-11-27 10:30:00	SPY	ETF	314.53	314.759	314.39	314.68	2620506.0
2019-11-27 11:00:00	SPY	ETF	314.68	314.76	314.5	314.68	1875624.0
2019-11-27 11:30:00	SPY	ETF	314.68	314.89	314.63	314.85	5255660.0
2019-11-27 12:00:00	SPY	ETF	314.855	315.0	314.84	314.87	1360573.0
2019-11-27 12:30:00	SPY	ETF	314.87	315.01	314.84	314.935	1111870.0
2019-11-27 13:00:00	SPY	ETF	314.94	315.33	314.9	315.2695	2620093.0
2019-11-27 13:30:00	SPY	ETF	315.2741	315.42	315.25	315.295	1930847.0
2019-11-27 14:00:00	SPY	ETF	315.2905	315.38	315.21	315.375	1275803.0
2019-11-27 14:30:00	SPY	ETF	315.37	315.44	315.29	315.335	1468658.0
2019-11-27 15:00:00	SPY	ETF	315.335	315.45	315.25	315.4	2357526.0
2019-11-27 15:30:00	SPY	ETF	315.4	315.47	315.23	315.44	5826910.0
2019-11-27 16:00:00	SPY	ETF	315.43	315.57	315.33	315.4	4669244.0
2019-11-27 16:30:00	SPY	ETF	315.4	315.55	314.0743	315.5	794632.0
2019-11-27 17:00:00	SPY	ETF	315.5	315.53	315.47	315.47	348050.0
2019-11-27 17:30:00	SPY	ETF	315.51	315.6	315.48	315.52	10825.0
2019-11-27 18:00:00	SPY	ETF	315.57	315.57	314.41	314.6	276588.0
2019-11-27 18:30:00	SPY	ETF	314.62	314.62	314.49	314.55	122951.0
2019-11-27 19:00:00	SPY	ETF	314.59	314.75	314.45	314.55	51129.0
2019-11-27 19:30:00	SPY	ETF	314.5	314.58	314.36	314.52	73176.0
2019-11-27 04:00:00	QQQ	ETF	205.26	205.4	205.26	205.4	3490.0
2019-11-27 04:30:00	QQQ	ETF	205.48	205.48	205.4	205.47	4436.0
2019-11-27 05:00:00	QQQ	ETF	205.49	205.49	205.44	205.44	300.0
2019-11-27 05:30:00	QQQ	ETF	205.46	205.48	205.42	205.46	1850.0
2019-11-27 06:00:00	QQQ	ETF	205.43	205.43	205.31	205.38	6500.0
2019-11-27 06:30:00	QQQ	ETF	205.34	205.34	205.28	205.28	2011.0
2019-11-27 07:00:00	QQQ	ETF	205.28	205.35	205.28	205.31	15725.0
2019-11-27 07:30:00	QQQ	ETF	205.3	205.32	205.22	205.27	28398.0
2019-11-27 08:00:00	QQQ	ETF	205.29	205.33	205.2199	205.23	10884.0
2019-11-27 08:30:00	QQQ	ETF	205.28	205.42	205.16	205.16	71253.0
2019-11-27 09:00:00	QQQ	ETF	205.15	205.23	205.13	205.14	67583.0
2019-11-27 09:30:00	QQQ	ETF	205.13	205.27	204.89	205.23	1942359.0
2019-11-27 10:00:00	QQQ	ETF	205.23	205.41	205.09	205.4	793824.0
2019-11-27 10:30:00	QQQ	ETF	205.41	205.56	205.33	205.5104	821671.0
2019-11-27 11:00:00	QQQ	ETF	205.53	205.64	205.46	205.59	724118.0
2019-11-27 11:30:00	QQQ	ETF	205.6	205.73	205.52	205.725	778175.0
2019-11-27 12:00:00	QQQ	ETF	205.72	205.86	205.69	205.73	674296.0
2019-11-27 12:30:00	QQQ	ETF	205.73	205.8	205.71	205.725	488162.0

> showing 50 of 17,727 rows — these rows as CSV

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