PREVIEW / etf_30min / 2010-12-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-21.parquet
  size:    265 KB
  rows:    8,989

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-12-21 04:00:00	SPY	ETF	124.6	124.99	124.6	124.96	4800.0
2010-12-21 05:30:00	SPY	ETF	124.9	124.94	124.9	124.94	900.0
2010-12-21 06:00:00	SPY	ETF	124.85	124.85	124.85	124.85	200.0
2010-12-21 06:30:00	SPY	ETF	124.86	124.91	124.86	124.87	19800.0
2010-12-21 07:00:00	SPY	ETF	124.87	124.9	124.85	124.88	297184.0
2010-12-21 07:30:00	SPY	ETF	124.88	124.95	124.87	124.92	310625.0
2010-12-21 08:00:00	SPY	ETF	124.92	125.08	124.89	125.05	687955.0
2010-12-21 08:30:00	SPY	ETF	125.06	125.08	124.97	125.02	484720.0
2010-12-21 09:00:00	SPY	ETF	125.01	125.07	124.95	124.98	727677.0
2010-12-21 09:30:00	SPY	ETF	124.99	125.135	124.87	125.02	12122794.0
2010-12-21 10:00:00	SPY	ETF	125.02	125.21	124.96	125.15	7888802.0
2010-12-21 10:30:00	SPY	ETF	125.15	125.2	125.09	125.15	7446827.0
2010-12-21 11:00:00	SPY	ETF	125.15	125.19	125.07	125.1838	5332699.0
2010-12-21 11:30:00	SPY	ETF	125.18	125.25	125.13	125.15	5323690.0
2010-12-21 12:00:00	SPY	ETF	125.16	125.265	125.15	125.24	3135521.0
2010-12-21 12:30:00	SPY	ETF	125.25	125.35	125.23	125.33	3806576.0
2010-12-21 13:00:00	SPY	ETF	125.33	125.34	125.24	125.26	4135296.0
2010-12-21 13:30:00	SPY	ETF	125.25	125.31	125.24	125.29	3131827.0
2010-12-21 14:00:00	SPY	ETF	125.28	125.311	125.25	125.28	3011120.0
2010-12-21 14:30:00	SPY	ETF	125.28	125.3	125.24	125.29	3782070.0
2010-12-21 15:00:00	SPY	ETF	125.3	125.35	125.25	125.32	4629376.0
2010-12-21 15:30:00	SPY	ETF	125.32	125.47	125.3	125.36	14598600.0
2010-12-21 16:00:00	SPY	ETF	125.36	125.44	124.8957	125.36	9407525.0
2010-12-21 16:30:00	SPY	ETF	125.36	125.39	125.3	125.37	1108056.0
2010-12-21 17:00:00	SPY	ETF	125.36	125.37	124.5866	125.34	1572647.0
2010-12-21 17:30:00	SPY	ETF	125.34	125.37	125.29	125.33	39041.0
2010-12-21 18:00:00	SPY	ETF	125.35	125.4	125.31	125.33	67276.0
2010-12-21 18:30:00	SPY	ETF	125.33	125.33	125.28	125.29	38000.0
2010-12-21 19:00:00	SPY	ETF	125.29	125.32	125.29	125.31	9850.0
2010-12-21 19:30:00	SPY	ETF	125.31	125.35	125.31	125.35	10351.0
2010-12-21 04:00:00	QQQ	ETF	54.67	54.67	54.67	54.67	700.0
2010-12-21 04:30:00	QQQ	ETF	54.66	54.66	54.66	54.66	246.0
2010-12-21 05:00:00	QQQ	ETF	54.67	54.67	54.67	54.67	500.0
2010-12-21 05:30:00	QQQ	ETF	54.66	54.66	54.66	54.66	200.0
2010-12-21 07:00:00	QQQ	ETF	54.64	54.65	54.64	54.65	15200.0
2010-12-21 07:30:00	QQQ	ETF	54.66	54.7	54.65	54.7	21400.0
2010-12-21 08:00:00	QQQ	ETF	54.69	54.75	54.69	54.74	52102.0
2010-12-21 08:30:00	QQQ	ETF	54.74	54.75	54.7	54.71	99052.0
2010-12-21 09:00:00	QQQ	ETF	54.71	54.77	54.71	54.77	212557.0
2010-12-21 09:30:00	QQQ	ETF	54.77	54.83	54.62	54.72	5006396.0
2010-12-21 10:00:00	QQQ	ETF	54.73	54.81	54.7	54.76	2490983.0
2010-12-21 10:30:00	QQQ	ETF	54.77	54.81	54.75	54.789	1309174.0
2010-12-21 11:00:00	QQQ	ETF	54.7875	54.81	54.75	54.81	992104.0
2010-12-21 11:30:00	QQQ	ETF	54.8	54.82	54.76	54.77	1050034.0
2010-12-21 12:00:00	QQQ	ETF	54.78	54.86	54.77	54.83	987354.0
2010-12-21 12:30:00	QQQ	ETF	54.83	54.88	54.81	54.87	703006.0
2010-12-21 13:00:00	QQQ	ETF	54.87	54.8701	54.82	54.84	950205.0
2010-12-21 13:30:00	QQQ	ETF	54.83	54.86	54.82	54.84	755562.0
2010-12-21 14:00:00	QQQ	ETF	54.841	54.86	54.83	54.84	1194218.0
2010-12-21 14:30:00	QQQ	ETF	54.83	54.86	54.81	54.83	1923271.0

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

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