PREVIEW / etf_30min / 2018-03-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-06.parquet
  size:    478 KB
  rows:    16,486

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-06 04:00:00	SPY	ETF	272.43	272.64	272.39	272.61	12532.0
2018-03-06 04:30:00	SPY	ETF	272.51	272.64	272.43	272.62	4700.0
2018-03-06 05:00:00	SPY	ETF	272.64	272.64	272.37	272.37	1833.0
2018-03-06 05:30:00	SPY	ETF	272.51	272.71	272.51	272.66	44300.0
2018-03-06 06:00:00	SPY	ETF	272.67	273.25	272.61	273.13	25750.0
2018-03-06 06:30:00	SPY	ETF	273.29	273.57	273.1	273.37	59877.0
2018-03-06 07:00:00	SPY	ETF	273.38	273.38	273.0	273.0	127056.0
2018-03-06 07:30:00	SPY	ETF	272.93	273.21	272.92	273.18	84987.0
2018-03-06 08:00:00	SPY	ETF	273.21	273.38	271.94	273.02	229689.0
2018-03-06 08:30:00	SPY	ETF	273.0	273.14	272.72	272.83	287002.0
2018-03-06 09:00:00	SPY	ETF	272.94	273.29	272.73	273.24	400661.0
2018-03-06 09:30:00	SPY	ETF	273.3	273.39	272.1289	272.675	7715503.0
2018-03-06 10:00:00	SPY	ETF	272.68	272.9	271.9	272.78	7230864.0
2018-03-06 10:30:00	SPY	ETF	272.76	273.0	271.46	271.6486	4997574.0
2018-03-06 11:00:00	SPY	ETF	271.65	272.2093	271.28	271.55	9440607.0
2018-03-06 11:30:00	SPY	ETF	271.56	272.14	271.18	272.12	2933022.0
2018-03-06 12:00:00	SPY	ETF	272.105	272.16	271.59	271.665	2884787.0
2018-03-06 12:30:00	SPY	ETF	271.66	272.94	271.5825	272.93	3999569.0
2018-03-06 13:00:00	SPY	ETF	272.93	273.155	272.75	272.97	3564736.0
2018-03-06 13:30:00	SPY	ETF	272.99	273.14	272.22	272.42	2529780.0
2018-03-06 14:00:00	SPY	ETF	272.4	272.61	272.16	272.35	3205035.0
2018-03-06 14:30:00	SPY	ETF	272.36	273.2	272.36	272.93	2558678.0
2018-03-06 15:00:00	SPY	ETF	272.94	273.02	272.33	272.8	4721956.0
2018-03-06 15:30:00	SPY	ETF	272.795	273.04	272.39	272.89	10501076.0
2018-03-06 16:00:00	SPY	ETF	272.94	272.94	272.48	272.51	5012065.0
2018-03-06 16:30:00	SPY	ETF	272.52	273.3239	272.51	272.53	245709.0
2018-03-06 17:00:00	SPY	ETF	272.6	272.6	271.5	271.5	1346535.0
2018-03-06 17:30:00	SPY	ETF	271.75	271.75	269.18	269.61	2449718.0
2018-03-06 18:00:00	SPY	ETF	269.65	270.15	269.16	269.2	1183105.0
2018-03-06 18:30:00	SPY	ETF	269.19	269.77	269.17	269.43	261220.0
2018-03-06 19:00:00	SPY	ETF	269.4	269.62	268.46	268.52	393200.0
2018-03-06 19:30:00	SPY	ETF	268.5	269.02	268.32	268.83	267365.0
2018-03-06 04:00:00	QQQ	ETF	168.0	168.3	168.0	168.27	4900.0
2018-03-06 04:30:00	QQQ	ETF	168.27	168.3	168.18	168.27	28858.0
2018-03-06 05:00:00	QQQ	ETF	168.1	168.24	168.08	168.21	2980.0
2018-03-06 05:30:00	QQQ	ETF	168.3	168.44	168.3	168.38	13086.0
2018-03-06 06:00:00	QQQ	ETF	168.38	168.7	168.35	168.63	32668.0
2018-03-06 06:30:00	QQQ	ETF	168.71	168.78	168.63	168.64	11400.0
2018-03-06 07:00:00	QQQ	ETF	168.71	168.73	168.5	168.5	72060.0
2018-03-06 07:30:00	QQQ	ETF	168.5	168.71	168.47	168.71	77760.0
2018-03-06 08:00:00	QQQ	ETF	168.71	168.75	168.5	168.57	122657.0
2018-03-06 08:30:00	QQQ	ETF	168.56	168.62	168.37	168.48	261686.0
2018-03-06 09:00:00	QQQ	ETF	168.5	168.72	168.4	168.62	485386.0
2018-03-06 09:30:00	QQQ	ETF	168.62	168.98	168.12	168.86	3939107.0
2018-03-06 10:00:00	QQQ	ETF	168.86	169.08	168.34	168.98	2529558.0
2018-03-06 10:30:00	QQQ	ETF	168.98	169.11	167.87	167.96	1910692.0
2018-03-06 11:00:00	QQQ	ETF	167.97	168.21	167.51	167.67	2092429.0
2018-03-06 11:30:00	QQQ	ETF	167.67	168.24	167.48	168.23	1249619.0
2018-03-06 12:00:00	QQQ	ETF	168.224	168.33	167.95	168.0	932467.0
2018-03-06 12:30:00	QQQ	ETF	167.99	168.71	167.92	168.7	1275368.0

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

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