PREVIEW / etf_30min / 2020-10-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-30.parquet
  size:    579 KB
  rows:    21,481

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
2020-10-30 04:00:00	SPY	ETF	324.41	325.89	324.41	325.77	38762.0
2020-10-30 04:30:00	SPY	ETF	325.9	326.1	324.7	325.28	34740.0
2020-10-30 05:00:00	SPY	ETF	325.3	326.72	325.19	326.64	60713.0
2020-10-30 05:30:00	SPY	ETF	326.65	327.71	326.34	327.21	55412.0
2020-10-30 06:00:00	SPY	ETF	327.15	327.61	326.76	327.5	39218.0
2020-10-30 06:30:00	SPY	ETF	327.5	328.16	327.01	328.09	131169.0
2020-10-30 07:00:00	SPY	ETF	328.04	329.15	328.04	328.2	292692.0
2020-10-30 07:30:00	SPY	ETF	328.2	328.37	327.65	327.81	248321.0
2020-10-30 08:00:00	SPY	ETF	328.45	329.02	323.28	327.16	511638.0
2020-10-30 08:30:00	SPY	ETF	327.1	328.49	326.95	328.07	624288.0
2020-10-30 09:00:00	SPY	ETF	328.02	328.29	327.57	328.25	550373.0
2020-10-30 09:30:00	SPY	ETF	328.28	329.69	326.82	327.98	9221935.0
2020-10-30 10:00:00	SPY	ETF	327.98	328.54	324.92	325.26	6871868.0
2020-10-30 10:30:00	SPY	ETF	325.2599	325.67	323.23	323.24	9294786.0
2020-10-30 11:00:00	SPY	ETF	323.26	325.48	323.24	324.24	7524812.0
2020-10-30 11:30:00	SPY	ETF	324.25	325.03	323.55	324.84	6018610.0
2020-10-30 12:00:00	SPY	ETF	324.82	326.72	324.503	326.495	4116366.0
2020-10-30 12:30:00	SPY	ETF	326.495	326.54	324.87	324.95	3528214.0
2020-10-30 13:00:00	SPY	ETF	324.96	325.48	324.02	324.86	4159791.0
2020-10-30 13:30:00	SPY	ETF	324.83	324.83	323.34	324.5	4487577.0
2020-10-30 14:00:00	SPY	ETF	324.49	325.6399	323.61	323.785	4907606.0
2020-10-30 14:30:00	SPY	ETF	323.78	324.31	322.6	323.66	7069369.0
2020-10-30 15:00:00	SPY	ETF	323.67	324.67	323.11	323.79	8919847.0
2020-10-30 15:30:00	SPY	ETF	323.79	326.87	322.95	326.53	20264885.0
2020-10-30 16:00:00	SPY	ETF	326.52	330.2774	325.1341	327.39	17403167.0
2020-10-30 16:30:00	SPY	ETF	327.36	328.19	327.31	327.9	791161.0
2020-10-30 17:00:00	SPY	ETF	327.92	327.92	326.54	327.6802	262034.0
2020-10-30 17:30:00	SPY	ETF	327.68	327.98	327.68	327.89	94148.0
2020-10-30 18:00:00	SPY	ETF	327.93	327.95	327.71	327.78	43984.0
2020-10-30 18:30:00	SPY	ETF	327.8	327.8	327.32	327.55	30208.0
2020-10-30 19:00:00	SPY	ETF	327.53	327.59	327.2	327.2	41914.0
2020-10-30 19:30:00	SPY	ETF	327.19	327.44	327.18	327.3	55534.0
2020-10-30 04:00:00	QQQ	ETF	270.64	271.73	270.64	271.57	25718.0
2020-10-30 04:30:00	QQQ	ETF	271.57	271.82	270.81	271.28	33529.0
2020-10-30 05:00:00	QQQ	ETF	271.34	272.35	270.98	272.35	23860.0
2020-10-30 05:30:00	QQQ	ETF	272.4	273.1	272.18	272.5	33394.0
2020-10-30 06:00:00	QQQ	ETF	272.62	273.5	272.45	273.26	173269.0
2020-10-30 06:30:00	QQQ	ETF	273.24	274.12	273.1	273.88	181363.0
2020-10-30 07:00:00	QQQ	ETF	273.88	274.34	273.78	273.91	364098.0
2020-10-30 07:30:00	QQQ	ETF	273.94	274.04	273.57	273.97	183068.0
2020-10-30 08:00:00	QQQ	ETF	274.0599	274.34	269.86	273.36	291795.0
2020-10-30 08:30:00	QQQ	ETF	273.2302	274.62	273.2	274.29	266557.0
2020-10-30 09:00:00	QQQ	ETF	274.26	274.4	273.7398	274.36	202611.0
2020-10-30 09:30:00	QQQ	ETF	274.375	275.24	271.595	272.4352	5823949.0
2020-10-30 10:00:00	QQQ	ETF	272.4	273.0	269.64	269.94	3862569.0
2020-10-30 10:30:00	QQQ	ETF	269.92	270.335	268.11	268.12	5306501.0
2020-10-30 11:00:00	QQQ	ETF	268.13	270.0	268.11	268.52	3652006.0
2020-10-30 11:30:00	QQQ	ETF	268.48	268.86	267.92	268.53	2493556.0
2020-10-30 12:00:00	QQQ	ETF	268.51	270.78	268.24	270.62	2871521.0
2020-10-30 12:30:00	QQQ	ETF	270.61	270.625	268.8	268.96	2316865.0

> showing 50 of 21,481 rows — these rows as CSV

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