PREVIEW / etf_30min / 2010-04-28

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-28.parquet
  size:    260 KB
  rows:    8,696

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-04-28 04:00:00	SPY	ETF	118.55	118.6	118.39	118.39	8059.0
2010-04-28 04:30:00	SPY	ETF	118.41	118.41	118.23	118.28	3600.0
2010-04-28 05:00:00	SPY	ETF	118.41	118.55	118.33	118.39	40300.0
2010-04-28 05:30:00	SPY	ETF	118.31	118.57	118.2	118.51	16200.0
2010-04-28 06:00:00	SPY	ETF	118.51	118.78	118.5	118.64	7300.0
2010-04-28 06:30:00	SPY	ETF	118.58	118.78	118.4	118.78	133359.0
2010-04-28 07:00:00	SPY	ETF	118.77	119.14	118.77	119.14	707346.0
2010-04-28 07:30:00	SPY	ETF	119.1	119.2	118.91	118.93	997774.0
2010-04-28 08:00:00	SPY	ETF	118.92	119.16	118.07	119.1	1408243.0
2010-04-28 08:30:00	SPY	ETF	119.09	119.4	118.95	119.29	3453989.0
2010-04-28 09:00:00	SPY	ETF	119.3	119.47	119.03	119.05	5682973.0
2010-04-28 09:30:00	SPY	ETF	119.05	119.34	118.84	118.97	35791851.0
2010-04-28 10:00:00	SPY	ETF	118.97	119.11	118.66	119.02	24002818.0
2010-04-28 10:30:00	SPY	ETF	119.02	119.14	118.69	119.1301	20394695.0
2010-04-28 11:00:00	SPY	ETF	119.14	119.44	118.75	119.0	33366353.0
2010-04-28 11:30:00	SPY	ETF	118.99	119.13	118.27	118.85	37032160.0
2010-04-28 12:00:00	SPY	ETF	118.85	119.23	118.5	119.13	15881006.0
2010-04-28 12:30:00	SPY	ETF	119.13	119.25	119.0	119.17	8070117.0
2010-04-28 13:00:00	SPY	ETF	119.17	119.3	119.08	119.1099	6297129.0
2010-04-28 13:30:00	SPY	ETF	119.1075	119.27	119.1	119.2199	6077383.0
2010-04-28 14:00:00	SPY	ETF	119.22	119.68	119.1	119.47	20535469.0
2010-04-28 14:30:00	SPY	ETF	119.47	119.58	119.15	119.49	22510365.0
2010-04-28 15:00:00	SPY	ETF	119.48	119.63	119.27	119.42	12301958.0
2010-04-28 15:30:00	SPY	ETF	119.42	119.53	118.5225	119.33	28018175.0
2010-04-28 16:00:00	SPY	ETF	119.34	119.6	118.64	119.53	14182364.0
2010-04-28 16:30:00	SPY	ETF	119.53	119.56	119.45	119.53	218627.0
2010-04-28 17:00:00	SPY	ETF	119.56	119.64	119.53	119.59	154838.0
2010-04-28 17:30:00	SPY	ETF	119.61	119.65	119.55	119.57	63178.0
2010-04-28 18:00:00	SPY	ETF	119.57	119.66	119.55	119.63	29990.0
2010-04-28 18:30:00	SPY	ETF	119.67	119.67	119.55	119.6	48126.0
2010-04-28 19:00:00	SPY	ETF	119.59	119.63	119.59	119.62	18208.0
2010-04-28 19:30:00	SPY	ETF	119.63	119.63	119.58	119.6	42057.0
2010-04-28 04:30:00	QQQ	ETF	49.35	49.35	49.26	49.29	700.0
2010-04-28 05:00:00	QQQ	ETF	49.34	49.34	49.28	49.28	600.0
2010-04-28 05:30:00	QQQ	ETF	49.34	49.34	49.34	49.34	200.0
2010-04-28 06:00:00	QQQ	ETF	49.41	49.51	49.41	49.48	3100.0
2010-04-28 06:30:00	QQQ	ETF	49.49	49.54	49.44	49.53	32101.0
2010-04-28 07:00:00	QQQ	ETF	49.55	49.67	49.55	49.65	127830.0
2010-04-28 07:30:00	QQQ	ETF	49.67	49.71	49.64	49.64	173522.0
2010-04-28 08:00:00	QQQ	ETF	49.65	49.74	49.42	49.72	283666.0
2010-04-28 08:30:00	QQQ	ETF	49.72	49.79	49.68	49.76	713593.0
2010-04-28 09:00:00	QQQ	ETF	49.76	49.8	49.59	49.59	1698139.0
2010-04-28 09:30:00	QQQ	ETF	49.6	49.63	49.2805	49.34	14321863.0
2010-04-28 10:00:00	QQQ	ETF	49.34	49.36	49.09	49.3	17574814.0
2010-04-28 10:30:00	QQQ	ETF	49.3	49.34	49.07	49.25	6871881.0
2010-04-28 11:00:00	QQQ	ETF	49.25	49.36	49.1	49.1503	14789961.0
2010-04-28 11:30:00	QQQ	ETF	49.16	49.2308	48.98	49.16	17285751.0
2010-04-28 12:00:00	QQQ	ETF	49.16	49.28	49.035	49.26	4428597.0
2010-04-28 12:30:00	QQQ	ETF	49.25	49.28	49.17	49.2699	3634969.0
2010-04-28 13:00:00	QQQ	ETF	49.26	49.39	49.23	49.28	4497028.0

> showing 50 of 8,696 rows — these rows as CSV

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