PREVIEW / etf_30min / 2009-09-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-15.parquet
  size:    229 KB
  rows:    7,592

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
2009-09-15 05:00:00	SPY	ETF	104.87	104.92	104.86	104.86	3000.0
2009-09-15 05:30:00	SPY	ETF	104.97	104.97	104.97	104.97	1000.0
2009-09-15 06:00:00	SPY	ETF	105.03	105.13	105.03	105.13	6800.0
2009-09-15 06:30:00	SPY	ETF	105.18	105.18	105.18	105.18	2400.0
2009-09-15 07:00:00	SPY	ETF	105.17	105.22	105.08	105.09	192026.0
2009-09-15 07:30:00	SPY	ETF	105.06	105.37	105.02	105.35	223412.0
2009-09-15 08:00:00	SPY	ETF	105.35	105.38	105.0	105.18	1831174.0
2009-09-15 08:30:00	SPY	ETF	105.2	105.78	105.2	105.51	3732425.0
2009-09-15 09:00:00	SPY	ETF	105.51	105.56	105.33	105.46	1841283.0
2009-09-15 09:30:00	SPY	ETF	105.45	105.67	105.12	105.29	26667927.0
2009-09-15 10:00:00	SPY	ETF	105.29	105.62	104.76	105.25	30070214.0
2009-09-15 10:30:00	SPY	ETF	105.25	105.48	105.2	105.45	11786432.0
2009-09-15 11:00:00	SPY	ETF	105.44	105.47	105.1	105.12	11357088.0
2009-09-15 11:30:00	SPY	ETF	105.12	105.54	105.11	105.42	7261676.0
2009-09-15 12:00:00	SPY	ETF	105.43	105.53	105.35	105.44	5712995.0
2009-09-15 12:30:00	SPY	ETF	105.4401	105.64	105.36	105.62	5086167.0
2009-09-15 13:00:00	SPY	ETF	105.61	105.85	105.57	105.78	10130484.0
2009-09-15 13:30:00	SPY	ETF	105.77	105.91	105.69	105.8778	5624813.0
2009-09-15 14:00:00	SPY	ETF	105.87	105.9	105.7	105.84	6022894.0
2009-09-15 14:30:00	SPY	ETF	105.84	105.89	105.5	105.73	9821921.0
2009-09-15 15:00:00	SPY	ETF	105.74	106.11	105.65	106.01	17679425.0
2009-09-15 15:30:00	SPY	ETF	106.0199	106.03	105.64	105.72	21513037.0
2009-09-15 16:00:00	SPY	ETF	105.72	106.1	105.08	105.55	15358455.0
2009-09-15 16:30:00	SPY	ETF	105.53	105.54	105.33	105.42	1228698.0
2009-09-15 17:00:00	SPY	ETF	105.43	105.49	105.4	105.49	49311.0
2009-09-15 17:30:00	SPY	ETF	105.5	105.52	105.46	105.49	32066.0
2009-09-15 18:00:00	SPY	ETF	105.47	105.74	105.45	105.56	63405.0
2009-09-15 18:30:00	SPY	ETF	105.56	105.59	105.53	105.59	30675.0
2009-09-15 19:00:00	SPY	ETF	105.59	105.59	105.49	105.52	27115.0
2009-09-15 19:30:00	SPY	ETF	105.53	105.6	105.51	105.6	33472.0
2009-09-15 05:00:00	QQQ	ETF	41.48	41.49	41.48	41.48	1700.0
2009-09-15 06:00:00	QQQ	ETF	41.56	41.6	41.56	41.6	700.0
2009-09-15 06:30:00	QQQ	ETF	41.61	41.61	41.61	41.61	400.0
2009-09-15 07:00:00	QQQ	ETF	41.62	41.62	41.52	41.52	56170.0
2009-09-15 07:30:00	QQQ	ETF	41.62	41.66	41.62	41.65	15000.0
2009-09-15 08:00:00	QQQ	ETF	41.64	41.71	41.55	41.58	2999982.0
2009-09-15 08:30:00	QQQ	ETF	41.62	41.79	41.54	41.64	860797.0
2009-09-15 09:00:00	QQQ	ETF	41.65	41.67	41.57	41.67	782130.0
2009-09-15 09:30:00	QQQ	ETF	41.66	41.88	41.61	41.73	15545570.0
2009-09-15 10:00:00	QQQ	ETF	41.74	41.8	41.57	41.73	14892486.0
2009-09-15 10:30:00	QQQ	ETF	41.73	41.84	41.73	41.8286	4574955.0
2009-09-15 11:00:00	QQQ	ETF	41.8297	41.83	41.68	41.7176	3000637.0
2009-09-15 11:30:00	QQQ	ETF	41.71	41.86	41.71	41.82	2558841.0
2009-09-15 12:00:00	QQQ	ETF	41.82	41.84	41.77	41.81	1877552.0
2009-09-15 12:30:00	QQQ	ETF	41.8	41.86	41.76	41.84	1952736.0
2009-09-15 13:00:00	QQQ	ETF	41.84	41.9	41.82	41.87	4037215.0
2009-09-15 13:30:00	QQQ	ETF	41.88	41.91	41.85	41.9	2082286.0
2009-09-15 14:00:00	QQQ	ETF	41.8999	41.9	41.81	41.87	2724868.0
2009-09-15 14:30:00	QQQ	ETF	41.87	41.87	41.77	41.8201	2944148.0
2009-09-15 15:00:00	QQQ	ETF	41.83	41.95	41.81	41.9285	6708296.0

> showing 50 of 7,592 rows — these rows as CSV

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