PREVIEW / etf_30min / 2018-05-01

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-01.parquet
  size:    461 KB
  rows:    15,712

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-05-01 04:00:00	SPY	ETF	264.59	264.59	264.38	264.49	24881.0
2018-05-01 04:30:00	SPY	ETF	264.45	264.49	264.1	264.1	17403.0
2018-05-01 05:00:00	SPY	ETF	264.08	264.19	264.05	264.18	6808.0
2018-05-01 05:30:00	SPY	ETF	264.22	264.28	264.15	264.28	3800.0
2018-05-01 06:00:00	SPY	ETF	264.35	264.35	264.07	264.08	15310.0
2018-05-01 06:30:00	SPY	ETF	264.07	264.59	264.07	264.39	36970.0
2018-05-01 07:00:00	SPY	ETF	264.45	264.75	264.33	264.71	26599.0
2018-05-01 07:30:00	SPY	ETF	264.65	264.66	264.3	264.34	118652.0
2018-05-01 08:00:00	SPY	ETF	264.36	265.12	264.17	264.35	428287.0
2018-05-01 08:30:00	SPY	ETF	264.33	264.49	264.33	264.38	100946.0
2018-05-01 09:00:00	SPY	ETF	264.37	264.37	263.85	263.91	356606.0
2018-05-01 09:30:00	SPY	ETF	263.87	264.0699	263.37	263.93	6557286.0
2018-05-01 10:00:00	SPY	ETF	263.91	263.98	263.18	263.54	4802194.0
2018-05-01 10:30:00	SPY	ETF	263.52	263.71	262.93	262.97	3798207.0
2018-05-01 11:00:00	SPY	ETF	262.97	263.23	262.4452	263.01	4249125.0
2018-05-01 11:30:00	SPY	ETF	263.0	263.24	262.57	262.59	3395270.0
2018-05-01 12:00:00	SPY	ETF	262.59	263.14	262.5402	263.095	2505196.0
2018-05-01 12:30:00	SPY	ETF	263.1	263.19	262.67	262.855	2282250.0
2018-05-01 13:00:00	SPY	ETF	262.85	262.86	262.11	262.33	4104374.0
2018-05-01 13:30:00	SPY	ETF	262.32	263.69	262.3	263.6611	4643938.0
2018-05-01 14:00:00	SPY	ETF	263.665	264.2	263.62	264.04	4790750.0
2018-05-01 14:30:00	SPY	ETF	264.04	264.63	263.93	264.34	3349309.0
2018-05-01 15:00:00	SPY	ETF	264.33	264.579	263.76	263.97	4682476.0
2018-05-01 15:30:00	SPY	ETF	263.98	265.1	263.94	264.99	11121564.0
2018-05-01 16:00:00	SPY	ETF	264.99	265.23	264.82	264.98	6554397.0
2018-05-01 16:30:00	SPY	ETF	265.1	265.52	264.98	265.34	5262120.0
2018-05-01 17:00:00	SPY	ETF	265.25	265.25	264.92	265.19	117151.0
2018-05-01 17:30:00	SPY	ETF	265.19	265.29	265.18	265.29	37372.0
2018-05-01 18:00:00	SPY	ETF	265.31	265.44	265.3	265.3	25595.0
2018-05-01 18:30:00	SPY	ETF	265.3	265.39	265.3	265.38	4700.0
2018-05-01 19:00:00	SPY	ETF	265.41	265.41	265.16	265.18	15707.0
2018-05-01 19:30:00	SPY	ETF	265.15	265.43	265.15	265.43	15640.0
2018-05-01 04:00:00	QQQ	ETF	160.98	160.98	160.79	160.92	1603.0
2018-05-01 04:30:00	QQQ	ETF	160.85	160.85	160.51	160.51	14929.0
2018-05-01 05:00:00	QQQ	ETF	160.55	160.62	160.55	160.6	2500.0
2018-05-01 05:30:00	QQQ	ETF	160.58	160.69	160.5	160.69	5444.0
2018-05-01 06:00:00	QQQ	ETF	160.72	160.73	160.54	160.54	13200.0
2018-05-01 06:30:00	QQQ	ETF	160.55	161.02	160.55	160.83	44100.0
2018-05-01 07:00:00	QQQ	ETF	160.91	161.13	160.84	161.13	31107.0
2018-05-01 07:30:00	QQQ	ETF	161.03	161.09	160.75	160.79	53901.0
2018-05-01 08:00:00	QQQ	ETF	160.75	161.06	160.61	160.79	115209.0
2018-05-01 08:30:00	QQQ	ETF	160.8	160.99	160.8	160.86	198709.0
2018-05-01 09:00:00	QQQ	ETF	160.76	160.76	160.42	160.54	233250.0
2018-05-01 09:30:00	QQQ	ETF	160.54	161.14	160.14	161.05	4629502.0
2018-05-01 10:00:00	QQQ	ETF	161.03	161.46	160.58	161.26	3462678.0
2018-05-01 10:30:00	QQQ	ETF	161.25	161.47	160.85	160.86	2355354.0
2018-05-01 11:00:00	QQQ	ETF	160.86	161.17	160.3508	161.03	2356134.0
2018-05-01 11:30:00	QQQ	ETF	161.02	161.1799	160.54	160.59	1424241.0
2018-05-01 12:00:00	QQQ	ETF	160.58	161.12	160.58	161.1	1192224.0
2018-05-01 12:30:00	QQQ	ETF	161.12	161.16	160.7	160.899	919133.0

> showing 50 of 15,712 rows — these rows as CSV

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