PREVIEW / etf_30min / 2020-07-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-08.parquet
  size:    545 KB
  rows:    20,432

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-07-08 04:00:00	SPY	ETF	314.61	314.82	314.28	314.68	14067.0
2020-07-08 04:30:00	SPY	ETF	314.65	315.33	314.29	314.34	25899.0
2020-07-08 05:00:00	SPY	ETF	314.45	314.45	313.25	313.55	33545.0
2020-07-08 05:30:00	SPY	ETF	313.5	313.8	313.1	313.46	93206.0
2020-07-08 06:00:00	SPY	ETF	313.32	313.61	313.14	313.51	17985.0
2020-07-08 06:30:00	SPY	ETF	313.51	314.09	313.51	314.09	51555.0
2020-07-08 07:00:00	SPY	ETF	314.07	314.32	313.8	313.91	77606.0
2020-07-08 07:30:00	SPY	ETF	313.92	314.675	313.9	314.41	123058.0
2020-07-08 08:00:00	SPY	ETF	314.49	314.67	313.72	314.15	193884.0
2020-07-08 08:30:00	SPY	ETF	314.2	314.35	313.76	314.24	224986.0
2020-07-08 09:00:00	SPY	ETF	314.21	314.6	313.94	314.6	253073.0
2020-07-08 09:30:00	SPY	ETF	314.61	316.19	314.21	316.0987	5581921.0
2020-07-08 10:00:00	SPY	ETF	316.1	316.3	315.12	315.245	3490437.0
2020-07-08 10:30:00	SPY	ETF	315.25	315.77	315.04	315.39	2631984.0
2020-07-08 11:00:00	SPY	ETF	315.38	315.47	312.7	313.47	5945277.0
2020-07-08 11:30:00	SPY	ETF	313.47	314.37	313.34	314.14	3928316.0
2020-07-08 12:00:00	SPY	ETF	314.14	314.73	313.99	314.5808	2614811.0
2020-07-08 12:30:00	SPY	ETF	314.59	314.94	314.1	314.915	2280817.0
2020-07-08 13:00:00	SPY	ETF	314.9101	314.95	313.58	313.93	2277744.0
2020-07-08 13:30:00	SPY	ETF	313.93	314.43	313.7	313.86	2125997.0
2020-07-08 14:00:00	SPY	ETF	313.86	314.64	313.6	314.3859	2273799.0
2020-07-08 14:30:00	SPY	ETF	314.4	314.71	313.82	314.57	2569214.0
2020-07-08 15:00:00	SPY	ETF	314.575	315.95	314.525	315.5501	4940584.0
2020-07-08 15:30:00	SPY	ETF	315.545	316.17	315.1608	316.12	7939927.0
2020-07-08 16:00:00	SPY	ETF	316.11	316.49	315.94	316.37	3201406.0
2020-07-08 16:30:00	SPY	ETF	316.4	316.71	316.0672	316.57	297786.0
2020-07-08 17:00:00	SPY	ETF	316.56	316.59	316.52	316.54	53809.0
2020-07-08 17:30:00	SPY	ETF	316.54	316.68	316.51	316.59	58447.0
2020-07-08 18:00:00	SPY	ETF	316.62	316.91	316.62	316.78	106270.0
2020-07-08 18:30:00	SPY	ETF	316.8	316.87	316.6	316.68	49931.0
2020-07-08 19:00:00	SPY	ETF	316.68	316.89	316.59	316.8	47740.0
2020-07-08 19:30:00	SPY	ETF	316.79	317.05	316.62	316.85	229273.0
2020-07-08 04:00:00	QQQ	ETF	257.68	257.88	257.5	257.78	18255.0
2020-07-08 04:30:00	QQQ	ETF	257.73	258.17	257.42	257.75	28287.0
2020-07-08 05:00:00	QQQ	ETF	257.72	257.75	256.87	256.95	34053.0
2020-07-08 05:30:00	QQQ	ETF	257.02	257.16	256.82	257.07	8600.0
2020-07-08 06:00:00	QQQ	ETF	257.04	257.37	256.97	257.37	9795.0
2020-07-08 06:30:00	QQQ	ETF	257.35	257.66	257.28	257.63	23089.0
2020-07-08 07:00:00	QQQ	ETF	257.57	257.88	257.57	257.71	44099.0
2020-07-08 07:30:00	QQQ	ETF	257.74	258.21	257.74	258.11	72861.0
2020-07-08 08:00:00	QQQ	ETF	258.18	258.23	256.57	257.74	91651.0
2020-07-08 08:30:00	QQQ	ETF	257.77	257.9	257.38	257.87	124835.0
2020-07-08 09:00:00	QQQ	ETF	257.85	258.01	257.62	258.01	89381.0
2020-07-08 09:30:00	QQQ	ETF	258.0	259.36	257.83	259.3	3122414.0
2020-07-08 10:00:00	QQQ	ETF	259.299	259.62	258.6005	258.68	1928914.0
2020-07-08 10:30:00	QQQ	ETF	258.69	259.38	258.62	259.32	1129821.0
2020-07-08 11:00:00	QQQ	ETF	259.33	259.3879	256.5	257.3361	2909425.0
2020-07-08 11:30:00	QQQ	ETF	257.3135	258.43	257.21	258.3501	1715510.0
2020-07-08 12:00:00	QQQ	ETF	258.37	258.87	258.18	258.6499	1437881.0
2020-07-08 12:30:00	QQQ	ETF	258.6588	259.25	258.21	259.25	1099921.0

> showing 50 of 20,432 rows — these rows as CSV

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