PREVIEW / etf_30min / 2010-05-05

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-05.parquet
  size:    270 KB
  rows:    9,009

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
2010-05-05 04:00:00	SPY	ETF	117.37	117.55	117.37	117.44	3100.0
2010-05-05 04:30:00	SPY	ETF	117.41	117.7	117.41	117.66	2200.0
2010-05-05 05:00:00	SPY	ETF	117.68	117.84	117.68	117.84	10200.0
2010-05-05 05:30:00	SPY	ETF	117.84	117.96	117.83	117.96	22500.0
2010-05-05 06:00:00	SPY	ETF	117.96	117.96	117.76	117.82	13500.0
2010-05-05 06:30:00	SPY	ETF	117.79	117.79	117.59	117.59	49500.0
2010-05-05 07:00:00	SPY	ETF	117.6	117.62	117.36	117.56	1232390.0
2010-05-05 07:30:00	SPY	ETF	117.52	117.55	117.24	117.31	1302154.0
2010-05-05 08:00:00	SPY	ETF	117.32	117.51	116.91	117.03	3562081.0
2010-05-05 08:30:00	SPY	ETF	117.03	118.0	116.61	116.67	3790268.0
2010-05-05 09:00:00	SPY	ETF	116.67	116.81	116.29	116.55	8856420.0
2010-05-05 09:30:00	SPY	ETF	116.56	116.85	115.97	116.81	48057267.0
2010-05-05 10:00:00	SPY	ETF	116.8101	117.26	116.62	116.84	33535825.0
2010-05-05 10:30:00	SPY	ETF	116.841	117.43	116.75	117.25	24346200.0
2010-05-05 11:00:00	SPY	ETF	117.25	117.33	116.79	117.17	18296684.0
2010-05-05 11:30:00	SPY	ETF	117.17	117.78	117.04	117.68	17208126.0
2010-05-05 12:00:00	SPY	ETF	117.69	117.8	117.22	117.29	18466135.0
2010-05-05 12:30:00	SPY	ETF	117.28	117.45	116.97	117.28	14842325.0
2010-05-05 13:00:00	SPY	ETF	117.28	117.47	116.29	117.26	9728408.0
2010-05-05 13:30:00	SPY	ETF	117.26	117.37	117.05	117.15	12120800.0
2010-05-05 14:00:00	SPY	ETF	117.142	117.2	116.79	116.84	14970971.0
2010-05-05 14:30:00	SPY	ETF	116.842	117.15	116.24	116.6	28046189.0
2010-05-05 15:00:00	SPY	ETF	116.59	116.85	116.47	116.6782	17313725.0
2010-05-05 15:30:00	SPY	ETF	116.68	116.92	116.35	116.83	32415278.0
2010-05-05 16:00:00	SPY	ETF	116.84	117.56	116.18	116.85	11548787.0
2010-05-05 16:30:00	SPY	ETF	116.87	117.5592	116.82	116.83	1358486.0
2010-05-05 17:00:00	SPY	ETF	116.87	116.97	116.8	116.97	223759.0
2010-05-05 17:30:00	SPY	ETF	116.95	116.97	116.91	116.94	48877.0
2010-05-05 18:00:00	SPY	ETF	116.95	117.05	116.82	117.03	83404.0
2010-05-05 18:30:00	SPY	ETF	117.05	117.13	117.05	117.1	35039.0
2010-05-05 19:00:00	SPY	ETF	117.1	117.18	117.02	117.12	19000.0
2010-05-05 19:30:00	SPY	ETF	117.15	117.15	117.03	117.13	42750.0
2010-05-05 05:00:00	QQQ	ETF	48.48	48.51	48.48	48.49	1100.0
2010-05-05 06:00:00	QQQ	ETF	48.45	48.45	48.45	48.45	200.0
2010-05-05 06:30:00	QQQ	ETF	48.41	48.41	48.41	48.41	100.0
2010-05-05 07:00:00	QQQ	ETF	48.37	48.39	48.3	48.37	14648.0
2010-05-05 07:30:00	QQQ	ETF	48.37	48.4	48.28	48.3	12509.0
2010-05-05 08:00:00	QQQ	ETF	48.32	48.49	48.2	48.24	288742.0
2010-05-05 08:30:00	QQQ	ETF	48.24	48.24	47.93	47.98	1745716.0
2010-05-05 09:00:00	QQQ	ETF	47.98	48.05	47.84	47.97	4146274.0
2010-05-05 09:30:00	QQQ	ETF	47.98	47.98	47.64	47.94	20655158.0
2010-05-05 10:00:00	QQQ	ETF	47.94	48.2	47.87	47.99	15718267.0
2010-05-05 10:30:00	QQQ	ETF	47.99	48.29	47.95	48.26	9352893.0
2010-05-05 11:00:00	QQQ	ETF	48.2601	48.34	48.04	48.24	5512769.0
2010-05-05 11:30:00	QQQ	ETF	48.24	48.5	48.1901	48.46	5221251.0
2010-05-05 12:00:00	QQQ	ETF	48.46	48.49	48.15	48.17	10486859.0
2010-05-05 12:30:00	QQQ	ETF	48.16	48.27	48.1	48.24	5125082.0
2010-05-05 13:00:00	QQQ	ETF	48.24	48.38	48.15	48.28	5277112.0
2010-05-05 13:30:00	QQQ	ETF	48.29	48.33	48.2	48.23	4111935.0
2010-05-05 14:00:00	QQQ	ETF	48.24	48.27	48.12	48.15	3696027.0

> showing 50 of 9,009 rows — these rows as CSV

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